/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 vote301 views1 answer
Python sql last insertend
SQL
0 vote275 views2 answers
Android sqlite query join
SQL
0 vote268 views2 answers
Sql 2 way of select unique
SQL
0 vote274 views1 answer
Show database not empty tables postgres
SQL
0 vote281 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
1 vote283 views1 answer
Mysql drop key
SQL
0 vote302 views1 answer
Delete a temporary table mysql
SQL
6 votes317 views4 answers
Mysql get random row
SQL
9 votes290 views4 answers
Mysql set id auto increment
SQL
10 votes287 views2 answers
Oracle alter sequence nextval
SQL