/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

12 votes352 views4 answers
Import mysql database command line linux
SQL
2 votes341 views1 answer
Oracle convert run_duration to number
SQL
1 vote341 views1 answer
Rermove categories woocommerce sql
SQL
0 vote369 views1 answer
Check if string is a number sql
SQL
3 votes386 views1 answer
Laravel paginate raw sql
SQL
1 vote301 views1 answer
Insert into sql
SQL
0 vote345 views1 answer
NLS_NCHAR_CHARACTERSET
SQL
0 vote366 views1 answer
How to print some string in mysql
SQL
0 vote370 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
14 votes353 views4 answers
Remove record from table sql
SQL