/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

1 vote186 views1 answer
Mysql check if string contains comma separated
SQL
0 vote197 views1 answer
Oracle table free space
SQL
0 vote179 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote186 views1 answer
Flask sqlalchemy update row
SQL
0 vote207 views1 answer
Postgresql in vs any performance
SQL
0 vote200 views1 answer
Sql server count all tables rows
SQL
0 vote217 views1 answer
Unique element in sql
SQL
0 vote189 views1 answer
Mysql earlier than date
SQL
0 vote183 views1 answer
Console output pl sql
SQL
0 vote201 views1 answer
Alter check command
SQL