how to add a new column 2ffield to an existing composite primary key

Solutions on MaxInterview for how to add a new column 2ffield to an existing composite primary key by the best coders in the world

Search
showing results for - "how to add a new column 2ffield to an existing composite primary key"
Beatrice
21 Sep 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>
similar questions
alter table add column forigen key mysqlalter table add key sql serverliquibase add column to existing primary keyscript to add new column in table sqladd primary key to existing table sqlsql add calculated columnsql alter table add column if existsadd primary key to tablemysql add text to existing fieldt sql add columncreate new table from existing table with data in sql serversql server add columnsql server add primary key to existing table with dataadd computed column to table sql serveradd new column after in sqlsql add column bitsqlserver add column to tableadd new column in sql with foreign keyadd primary key to database sqlsql server microsoft how to add column at specific location in table
queries leading to this page
add new column to df by primaty keyhow to add a new column 2ffield to an existing composite primary keyhow to add a new column 2ffield to an existing composite primary key