/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 vote306 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote324 views1 answer
Sql mod even odd
SQL
1 vote303 views1 answer
Add constraint sql
SQL
0 vote327 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
21 votes273 views7 answers
Table drop if exist sql server
SQL
0 vote347 views1 answer
Sql with example
SQL
4 votes327 views3 answers
Is not null sql
SQL
0 vote363 views1 answer
Delete from IN subquery
SQL
1 vote320 views1 answer
Psql lst trigger
SQL
0 vote313 views1 answer
Mysql dump everythign
SQL