/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

3 votes209 views2 answers
Install mysql powershell
SQL
2 votes187 views2 answers
Sqlite_busy: database is locked
SQL
1 vote202 views2 answers
Change table name phpmyadmin
SQL
0 vote252 views1 answer
Download sql file of countries names
SQL
4 votes195 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote204 views1 answer
What is default mysql database password in linux
SQL
2 votes203 views1 answer
Apex execute batch job
SQL
8 votes232 views2 answers
Replace string value in sql
SQL
0 vote215 views1 answer
SQL add a totals of differemt rows of the same id
SQL
0 vote196 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL