/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 vote128 views1 answer
How to drop function in sql
SQL
18 votes126 views3 answers
Mysql current date
SQL
1 vote143 views1 answer
How to put value in variable mysql
SQL
0 vote120 views1 answer
Python mysql query where
SQL
2 votes145 views4 answers
2nd highest salary in mysql
SQL
1 vote125 views1 answer
Data type and their numeric form
SQL
7 votes132 views2 answers
Html to react converter
SQL
0 vote155 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote121 views1 answer
Oracle list subpartitions
SQL
0 vote128 views1 answer
Can we rollback in sql
SQL