/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

5 votes224 views1 answer
Oracle ora-00054 resource busy
SQL
3 votes211 views1 answer
Postgres update column with value from another table
SQL
2 votes225 views1 answer
Oracle list duplicates
SQL
0 vote239 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote229 views2 answers
How to prevent sql injection in java
SQL
1 vote224 views3 answers
Reset sql primary key
SQL
0 vote208 views1 answer
Query to insert image
SQL
7 votes218 views2 answers
Show size database mysql
SQL
3 votes223 views2 answers
Oracle sql select all days between two dates except weekends
SQL
1 vote178 views1 answer
Mssql string length
SQL