alter table to add primary key code example

Example 1: add primary key to existing table sql

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

Example 2: alter table add key sql server

ALTER TABLE Persons
ADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName);

Example 3: add primary key to existing table sql

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

--

Tags:

Sql Example

Related