/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 vote384 views1 answer
Mysql wait_timeout
SQL
5 votes353 views1 answer
Update sql user password
SQL
2 votes334 views1 answer
Username sql
SQL
0 vote344 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
2 votes354 views1 answer
How to get weekday from old date in sql
SQL
1 vote441 views1 answer
Oracle columns table
SQL
0 vote362 views1 answer
Oracle archivelog usage
SQL
4 votes369 views2 answers
Postgres update single column
SQL
1 vote367 views1 answer
Snowflake rename column name
SQL
1 vote348 views1 answer
Sqlite3 read only
SQL