/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 vote275 views1 answer
Power query datetime to date
SQL
0 vote290 views1 answer
Sql cheetsheet
SQL
0 vote322 views1 answer
Firebase sql
SQL
0 vote300 views1 answer
Change redo log file size in mysql 5.6
SQL
1 vote289 views1 answer
Apex select list ORA-20999
SQL
1 vote294 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote266 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote298 views1 answer
Ms sql database data size
SQL
0 vote294 views1 answer
How to close external sql connection in laravel
SQL
1 vote283 views1 answer
Postgres regex remove special characters
SQL