/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 vote192 views1 answer
Opensuse stop MySQL
SQL
0 vote212 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote206 views1 answer
Postgresql auto increment not working
SQL
0 vote269 views1 answer
Get initials name in sql
SQL
0 vote210 views1 answer
T-sql check if data exists
SQL
1 vote217 views1 answer
Retrieve meaning
SQL
0 vote206 views1 answer
Query by column for substring sql
SQL
0 vote214 views1 answer
Mysql server not running
SQL
2 votes210 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote203 views1 answer
Change database name psql 8
SQL