/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

1 vote281 views1 answer
Sql to mongodb query converter
SQL
0 vote293 views1 answer
Oracle cpu metric
SQL
0 vote324 views1 answer
Dockerfile example for Django
SQL
3 votes274 views1 answer
Delete all content in table mysql
SQL
0 vote296 views1 answer
Postgresql show owner of database
SQL
2 votes289 views1 answer
How to show the whole table in sql
SQL
0 vote299 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote258 views1 answer
Hallo
SQL
7 votes293 views3 answers
Sql server reset auto increment
SQL
0 vote295 views1 answer
Mysql page segment
SQL