/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

8 votes174 views1 answer
Oracle add datafile to tablespace
SQL
15 votes156 views3 answers
Find duplicate keys in mysql
SQL
0 vote146 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
10 votes157 views1 answer
Oracle dba_dependencies
SQL
1 vote161 views2 answers
Mysql update table from another table
SQL
0 vote156 views1 answer
Select the date 30 days less that the todays date sql request
SQL
2 votes140 views1 answer
Sqlplus clear screen
SQL
5 votes140 views1 answer
Mysql add user with all privileges
SQL
1 vote153 views2 answers
Mysql join two tables
SQL
23 votes121 views3 answers
Mysqldump
SQL