/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

9 votes267 views1 answer
Sql server get utc date
SQL
0 vote286 views1 answer
How to generate ids in sql
SQL
2 votes280 views5 answers
Install postgresql 10 centos 7
SQL
6 votes242 views1 answer
Oracle trigger after connect
SQL
0 vote276 views1 answer
Postgres list all stored procedures query
SQL
0 vote262 views1 answer
Mysql procedure between two tables
SQL
0 vote255 views1 answer
Mysql jdbc timezone
SQL
-1 vote279 views3 answers
My sql alter table
SQL
0 vote280 views1 answer
Mariadb create index if not exists
SQL
8 votes303 views6 answers
Insert command in sql
SQL