/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 vote227 views1 answer
Prisma transaction
SQL
0 vote170 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote171 views1 answer
Get employees if not contains in sql
SQL
0 vote165 views1 answer
Oracle current timestamp
SQL
0 vote176 views1 answer
Oracle archivemode
SQL
0 vote165 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
32 votes170 views6 answers
Insert select
SQL
0 vote188 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL
0 vote203 views1 answer
Sqlalchemy empty table
SQL
0 vote189 views1 answer
Dual in db2
SQL