/SQL/Add primary key to existing table sql

Add primary key to existing table sql

alter table Persion add primary key (persionId,Pname,PMID)

Source: stackoverflow.com

Change primary key sql

ALTER TABLE <Table_Name>
DROP CONSTRAINT <constraint_name>

ALTER TABLE <Table_Name>
ADD CONSTRAINT <constraint_name> PRIMARY KEY (<Column1>,<Column2>)

Source: stackoverflow.com

Add primary key to existing table sql

ALTER TABLE `tblauto`
  ADD PRIMARY KEY (`id`);

--

Add primary key to database sql

CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    PRIMARY KEY (ID)
);

Similar codes

0 vote235 views3 answers
Sql query checker
SQL
0 vote224 views1 answer
Sql track modification
SQL
-1 vote227 views1 answer
Partial search in sql
SQL
1 vote207 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote184 views1 answer
Sql select rows with simlar names
SQL
31 votes213 views3 answers
Sql count(*)
SQL
2 votes227 views1 answer
Sql update alias
SQL
1 vote252 views1 answer
Write a query to create an empty table from an existing table?
SQL
1 vote214 views1 answer
Oracle user last connected
SQL
0 vote232 views1 answer
How to Remove milliseconds from Date time
SQL