/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 vote135 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
-2 votes144 views1 answer
Create trigger syntax
SQL
6 votes139 views2 answers
Mysql execute file
SQL
0 vote124 views1 answer
Calculate date and convert to yearsmysql
SQL
3 votes142 views1 answer
Sql insert inserted id
SQL
0 vote139 views1 answer
Sql server select value large text
SQL
3 votes165 views3 answers
Order by postgres
SQL
0 vote165 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote152 views2 answers
How to get the date from datetime in mysql
SQL
0 vote193 views1 answer
Sql ssrs
SQL