/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 votes112 views4 answers
Select random rows sql
SQL
0 vote130 views1 answer
Drop database using terminal postgres
SQL
1 vote120 views1 answer
Sql server update column based on another table
SQL
1 vote101 views1 answer
Oracle rolling back
SQL
3 votes117 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote125 views1 answer
Mysql conf.d exampel
SQL
5 votes113 views4 answers
Rollback to in sql
SQL
1 vote116 views1 answer
Oracle list constraints
SQL
49 votes133 views6 answers
Install mysql ubuntu
SQL
1 vote116 views5 answers
Sql 2nd highest salary
SQL