/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 vote148 views1 answer
Mysql terminal list table
SQL
0 vote148 views1 answer
Postgresql on conflict pair
SQL
0 vote148 views1 answer
Enable full text search mysql
SQL
0 vote165 views1 answer
Sql server on mac m1
SQL
1 vote167 views2 answers
Remove space in mysql
SQL
0 vote152 views1 answer
Linebreak sql
SQL
11 votes142 views2 answers
Oracle all source
SQL
0 vote176 views1 answer
Mysql backup query
SQL
5 votes173 views1 answer
How to get all table names in sql query
SQL
-1 vote157 views1 answer
Mysql select all columns and specific fields as
SQL