/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 vote142 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote130 views1 answer
Update sqlite
SQL
1 vote124 views1 answer
Print year of a date sql
SQL
20 votes153 views4 answers
How to find average in sql
SQL
8 votes111 views1 answer
Alter tablespace add datafile
SQL
0 vote118 views1 answer
How to open mysql in docker
SQL
0 vote120 views1 answer
Delete first row in sql
SQL
0 vote124 views1 answer
How to insert multiple values in a single column in sql
SQL
0 vote125 views1 answer
Get cpu details sql
SQL
0 vote125 views1 answer
Psql generate id in existing database
SQL