/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 vote102 views2 answers
Search stored procedures
SQL
0 vote92 views1 answer
CREATE MULTIPLE FK
SQL
0 vote119 views1 answer
Mysql delete from where like
SQL
0 vote109 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
7 votes113 views1 answer
Buy forge mods server hosting
SQL
5 votes142 views2 answers
Functions
SQL
0 vote117 views1 answer
Mysql make date from 2 column
SQL
0 vote110 views1 answer
Mysql date time string format for marshmellow field schema
SQL
0 vote149 views1 answer
AddEntityFrameworkSqlite
SQL
6 votes115 views2 answers
Insert into select mysql
SQL