/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 vote299 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote293 views1 answer
Add alternate add column sql
SQL
0 vote327 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
15 votes297 views3 answers
Create table with primary key auto increment in sql
SQL
32 votes382 views6 answers
Rename column mysql
SQL
19 votes291 views6 answers
Laravel sql query
SQL
1 vote300 views1 answer
Add current timestamp in mysql
SQL
2 votes283 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote265 views1 answer
Connection error in mysql workbench
SQL
0 vote322 views1 answer
Postegresql update to null
SQL