/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 vote212 views1 answer
Oracle plsql sleep
SQL
-1 vote170 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote190 views1 answer
How convert into in in sql query
SQL
11 votes175 views4 answers
Query DISTINCT
SQL
0 vote181 views1 answer
Comma seperated join mssql
SQL
0 vote190 views1 answer
Sql alchemy escape ; in insert statement
SQL
2 votes198 views3 answers
Postgres create view
SQL
0 vote177 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
3 votes187 views1 answer
Oracle revoke grant
SQL
0 vote263 views1 answer
Sql insert exemplo
SQL