/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 vote103 views1 answer
Sqlite referential integrity
SQL
1 vote55 views1 answer
Python escape string for sql
SQL
-1 vote93 views2 answers
How to select the lowest values from table per client sql
SQL
1 vote109 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
4 votes122 views3 answers
Postgres drop all tables
SQL
1 vote109 views1 answer
Postgresql float 2 decimal places
SQL
0 vote118 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote126 views1 answer
Doctors appointment
SQL
2 votes102 views2 answers
Exec procedure pl sql
SQL
1 vote92 views1 answer
Mysql size int
SQL