Add support for AddNullConstraint and DropNullConstraint to Firebird
Description
Environment
Windows 10 PRO x64, JDK 1.8.121, liquibase 3.5.1
Activity
Show:
Details
Details
Reporter
Roberto Neto
Roberto NetoComponents
Affects versions
Priority
Created February 3, 2017 at 6:36 PM
Updated February 3, 2017 at 6:36 PM
Please add support for FirebirdDatabase:
AddNullConstraint
DropNullConstraint
Liquibase can do this using a simple update DML.
Dropping null constraint
update RDB$RELATION_FIELDS set RDB$NULL_FLAG = NULL where (RDB$FIELD_NAME = 'COLUMN_NAME') and (RDB$RELATION_NAME = 'TABLE_NAME')
Adding null constraint
update RDB$RELATION_FIELDS set RDB$NULL_FLAG = 1 where (RDB$FIELD_NAME = 'COLUMN_NAME') and (RDB$RELATION_NAME = 'TABLE_NAME')