/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 vote185 views1 answer
How to select only a certain date sql
SQL
0 vote319 views1 answer
Android sqlite add column if not exists
SQL
6 votes184 views2 answers
Postgresql restore from dump
SQL
0 vote197 views1 answer
Mysql change innodb to myisam
SQL
0 vote179 views1 answer
Sql server get date of previous sunday
SQL
0 vote178 views3 answers
Sql all columns
SQL
8 votes152 views1 answer
Similarities between ddl and dml
SQL
5 votes144 views1 answer
Copy table from one database to another mysql
SQL
1 vote218 views1 answer
Apex run 404
SQL
0 vote168 views1 answer
How to get initials in sql
SQL