/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

2 votes352 views2 answers
Mysql alter column default
SQL
4 votes333 views1 answer
Force drop all tables postgres
SQL
1 vote345 views1 answer
Mysql how to reset primary key
SQL
1 vote369 views1 answer
Nvl postgres
SQL
1 vote342 views3 answers
How to get date in sql
SQL
0 vote348 views3 answers
Postgresql allow remote connections
SQL
16 votes350 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote353 views1 answer
Sql gather statistics to increase performance
SQL
1 vote353 views2 answers
Select into temp table
SQL
1 vote323 views1 answer
Using SQL in rails migration
SQL