/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

1 vote216 views1 answer
Wherein mysql
SQL
2 votes190 views1 answer
Docker run postgres locally
SQL
1 vote183 views2 answers
Laravel get sql query eloquent with parameters
SQL
1 vote187 views1 answer
Altrer name column postgres
SQL
1 vote192 views2 answers
Mysql between
SQL
16 votes181 views1 answer
CTE statement sql server
SQL
2 votes167 views1 answer
Sql alchemy or
SQL
1 vote189 views1 answer
Wordpress change http to https phpmyadmin
SQL
1 vote286 views1 answer
Alter constraint postgres
SQL
3 votes277 views1 answer
Postgresql today - 1 year
SQL