/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 vote358 views1 answer
Sql server remove enter from string
SQL
0 vote292 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote386 views1 answer
Mysql grant user privileges to database that has suffix and prefix
SQL
1 vote385 views1 answer
Altrer name column postgres
SQL
0 vote342 views1 answer
Sqlite referential integrity
SQL
1 vote376 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
10 votes352 views6 answers
Mysql delete duplicates
SQL
0 vote350 views1 answer
Big table in mysql
SQL
0 vote364 views2 answers
Postgres having
SQL
1 vote339 views2 answers
Sql multiline comment
SQL