Adam Wuerl
Adam Wuerl
Programming language:SQL
2021-05-09 10:55:41
0
Q:

sql change primary key to composite key

ChronoD
ChronoD
Code: SQL
2021-07-15 20:36:15 
ALTER TABLE <Table_Name>
DROP CONSTRAINT <constraint_name>

ALTER TABLE <Table_Name>
ADD CONSTRAINT <constraint_name> PRIMARY KEY (<Column1>,<Column2>)
1
Aninha
Aninha
Code: SQL
2021-02-22 05:08:32 
    /* For SQL Server/Oracle/MS ACCESS */
    ALTER TABLE  AgentIdentification 
    DROP CONSTRAINT PK_Table1_Col1


    /* For MySql */
    ALTER TABLE  AgentIdentification 
    DROP PRIMARY KEY
0

Tags

Related

New to Communities?

Join the community