liquibase add column to existing primary key

Solutions on MaxInterview for liquibase add column to existing primary key by the best coders in the world

Search
showing results for - "liquibase add column to existing primary key"
Paula
10 Jun 2020
1 <changeSet author="yours_truly" id="EXAMPLE-02-01-dropPK">
2    <dropPrimaryKey  tableName= "our_awesome_table" constraintName="CPK_OUR_AWESOME_TABLE"/>
3 </changeSet>
4 
5 <changeSet author="yours_truly" id="EXAMPLE-02-01-addNNcol"> 
6     <addColumn tableName="our_awesome_table">
7         <column name="CREATED_AT" type="datetime" valueDate="current_datetime" defaultValueDate="current_datetime">
8            <constraints nullable="false"/>
9       </column>
10    </addColumn>
11</changeSet>
12
13<changeSet author="yours_truly" id="EXAMPLE-02-02">
14    <addPrimaryKey tableName="our_awesome_table" columnNames="source,external_id,CREATED_AT" constraintName="CPK_OUR_AWESOME_TABLE"/>
15</changeSet>
16
source
similar questions
mysql alter table add column firstmysql add columnliquibase alter column type 2f lengthalter table add column and foreign key mysqlmysql alter table add columnmysql add columnsadd new column in sql with foreign keyadd new column to the table mysqlalter table add column forigen key mysqlhow to add more columns to a table in mysqlmysql add column with default valuesql alter table add column if existsmysql add text to existing fieldsqlite alter table add columnadd column mysql with foreign keyadd column to all tables after first column mysqlhow to add a new column 2ffield to an existing composite primary keyadd column in mysqmysql add column to table
queries leading to this page
liquibase add column with primary keydrop primary key liquibaseliquibase add column to existing primary key