Table of Contents
"Add Column" Refactoring
Adds a new column to an existing table.
Sample
<addColumn tableName="person"> <column name="firstname" type="varchar(255)"/> </addColumn>
Available Attributes
| tableName | Name of the table to add the column to [required] |
|---|---|
| schemaName | Name of the table schema |
Available Sub-Tags
| column | Column constraint and foreign key information. Setting the “defaultValue” attribue will specify a default value for the column. Setting the “value” attribute will set all rows existing to the specified value without modifying the column default. See the column tag documentation for more information [required] |
|---|
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 | No Issues |
| MaxDB | No Issues |
Automatic Rollback Support: YES
