/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 votes143 views4 answers
Upload database mysql command line
SQL
0 vote145 views1 answer
SQL Error 1040 : Too many connections
SQL
14 votes130 views3 answers
Delete all records from table except sql
SQL
33 votes136 views6 answers
Sql delete
SQL
0 vote147 views1 answer
Oracle change password expiration policy
SQL
0 vote135 views1 answer
Mysql select inside sum
SQL
0 vote130 views2 answers
Oracle create chain rule
SQL
8 votes129 views2 answers
Update sql server from another table
SQL
0 vote137 views1 answer
Stored procedures example
SQL
0 vote282 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL