/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

2 votes259 views2 answers
Change varchar length mysql
SQL
1 vote256 views2 answers
How to add amount between date in sql
SQL
0 vote251 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote247 views1 answer
Mysql concat and use as where column
SQL
0 vote249 views1 answer
Mysql query single row
SQL
3 votes282 views3 answers
Raw select laravel
SQL
9 votes252 views3 answers
Oracle undo usage by session
SQL
0 vote314 views1 answer
How to rename a database in tsql
SQL
2 votes245 views2 answers
Join update query in sql
SQL
0 vote244 views1 answer
Uncomment listen_address=localhost
SQL