Translations of this page?:

Modify Column Refactoring

This tag is deprecated in 2.0 see Modify Datatype Refactoring instead.

Makes changes to an existing column such as the data type.

Sample

<modifyColumn tableName="person">
    <column name="firstname" type="varchar(5000)"/>
</modifyColumn>

Available Attributes

tableName Name of the table that the column to modify is in [required]
schemaName Name of the table schema

Available Sub-Tags

column New column definition See the column tag documentation for more information

Database Compatiblity

MySQL No Issues
PostgreSQL No Issues
Oracle No Issues
MS-SQL No Issues
Sybase No Issues
DB2 Some Issues
Derby No Issues
HSQL No Issues
H2 No Issues
Caché No Issues
Firebird No Issues
MaxDB No Issues
SQLite No Issues

Automatic Rollback Support: NO

Receive Liquibase Announcements
* indicates required
Page Actions
Wiki Actions
User Actions
Submit This Story
 
manual/modify_column.txt · Last modified: 2011/01/18 06:02 by 81.18.250.19