What is the default restriction setting for a campaign column?

I am creating a new table, for example:

<createTable tableName="myTable"> <column name="key" type="int" autoIncrement="true"> <constraints primaryKey="true" primaryKeyName="PK_myTable" nullable="false"/> </column> <column name="name" type="nvarchar(40)"> <constraints nullable="false"/> </column> <column name="description" type="nvarchar(100)"> <constraints nullable="true"/> </column> </createTable> 

As for the nullable restriction, if I omit this attribute, what is the default setting?

for example. If I did this only:

 <column name="description" type="nvarchar(100)"/> 

... will the column be null?

More importantly, where is the documentation that points this out (since I have other questions like this)?

I looked here: Liquibase Column Tag , but it only says ambiguously:

nullable - Is the column nullified?

+5
source share
1 answer

This is not documented, but I looked at the source code and it seems that if you do not specify, no restriction will be added to the column. One way to verify this yourself is to use the Liquibase updateSql to look at the generated SQL.

+4
source

Source: https://habr.com/ru/post/1232719/


All Articles