Table of Contents
Drop Not-Null Constraint
Makes a column nullable.
Sample
<dropNotNullConstraint tableName="employee" columnName="employer_id"/>
Available Attributes
| tableName | Name of the table containing that the column to drop the constraint from [required] |
|---|---|
| schemaName | Name of the table schema |
| columnName | Name of the column to drop the constraint from [required] |
| columnDataType | Current data type of the column [required for MySQL & MS-SQL] |
Database Compatiblity
| MySQL | No Issues |
|---|---|
| PostgreSQL | No Issues |
| Oracle | No Issues |
| MS-SQL | No Issues |
| Sybase | No Issues |
| DB2 | No Issues |
| Derby | No Issues |
| HSQL | No Issues |
| H2 | No Issues |
| Caché | No Issues |
| Firebird | Not Supported |
| MaxDB | No Issues |
Automatic Rollback Support: YES
