/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

0 vote259 views3 answers
Get count of null in column sql
SQL
0 vote282 views1 answer
Sqlite explain plan
SQL
16 votes312 views3 answers
Get count of duplicate records
SQL
0 vote252 views1 answer
How to see the query of a view in mysql
SQL
0 vote265 views1 answer
EnvironmentError: mysql_config not found
SQL
14 votes293 views2 answers
Oracle add attribute to table
SQL
-1 vote300 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote268 views2 answers
Return the number of records in a single table mysql
SQL
0 vote272 views1 answer
Varchar format not case sensitive sql
SQL
0 vote251 views1 answer
Dump only schema
SQL