/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

0 vote315 views1 answer
Print orcale
SQL
2 votes309 views1 answer
Match in sql server
SQL
0 vote323 views1 answer
Default value false mysql
SQL
10 votes350 views2 answers
SQL rounding numbers
SQL
0 vote395 views1 answer
Selecting specific day in colum sql
SQL
0 vote333 views1 answer
SQL authentication error
SQL
0 vote283 views1 answer
How to set field to null in sql
SQL
0 vote401 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
-1 vote326 views1 answer
What is in operator
SQL
1 vote333 views1 answer
Select from describe sql
SQL