/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

58 votes289 views6 answers
Create new user in postgres
SQL
1 vote147 views1 answer
Sql set auto increment back to 0
SQL
1 vote131 views1 answer
Altrer name column postgres
SQL
0 vote121 views1 answer
How to check even or odd in sql
SQL
0 vote129 views1 answer
Connect to nginx server mysql remotly
SQL
4 votes154 views5 answers
Get last query in codeigniter 4
SQL
4 votes121 views1 answer
Mysql copy table with new name
SQL
0 vote117 views1 answer
Call scalar valued function sql
SQL
0 vote129 views1 answer
Ubuntu stop mysql from starting on boot
SQL
2 votes123 views1 answer
Oracle apex list connected users
SQL