/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 vote202 views1 answer
Check if string is a number sql
SQL
0 vote199 views1 answer
Sql cursor example multiple columns
SQL
0 vote183 views1 answer
Check if table exists oracle
SQL
1 vote187 views1 answer
Mysql get character set
SQL
0 vote191 views1 answer
Azure sql server check foreign key
SQL
0 vote228 views1 answer
Stratified sampling sql
SQL
-1 vote204 views1 answer
What is in operator
SQL
-2 votes274 views1 answer
Mysql not empty
SQL
0 vote192 views1 answer
Mysql create table columns with spaces
SQL
0 vote195 views1 answer
Sqlite referential integrity
SQL