/SQL/Sql change primary key to composite key

Sql change primary key to composite key

    /* For SQL Server/Oracle/MS ACCESS */
    ALTER TABLE  AgentIdentification 
    DROP CONSTRAINT PK_Table1_Col1


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

Source: stackoverflow.com

Similar codes

1 vote198 views1 answer
Oracle list data files
SQL
15 votes195 views4 answers
Mysql where value is null
SQL
1 vote201 views1 answer
ORA-01950
SQL
1 vote192 views1 answer
How to delete a record from sqlite in android
SQL
0 vote189 views1 answer
Dump multiple tables mysql
SQL
0 vote192 views1 answer
How to find sql server name
SQL
14 votes208 views3 answers
Inner join sql oracle
SQL
0 vote194 views1 answer
Reona
SQL
8 votes205 views2 answers
Grant all privileges database postgres to user
SQL
0 vote203 views1 answer
Sql server list table sizes
SQL