/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

9 votes327 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote223 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote180 views1 answer
Sql script to remove default from column
SQL
0 vote180 views3 answers
Database restoring error
SQL
1 vote174 views1 answer
Mysql get last insert id
SQL
1 vote174 views1 answer
Mariadb get column names from table
SQL
0 vote178 views2 answers
How to display enum value sql server
SQL
6 votes168 views3 answers
Oracle all dates between two dates
SQL
0 vote194 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
3 votes211 views1 answer
Set default today mysql
SQL