/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 vote201 views1 answer
Sqlite create index
SQL
0 vote282 views2 answers
Execute stored procedure without db set
SQL
1 vote113 views1 answer
Oracle character set
SQL
1 vote151 views1 answer
How to delete record sql delphi
SQL
10 votes149 views1 answer
Create table oracle
SQL
11 votes161 views2 answers
Oracle source code
SQL
1 vote162 views1 answer
Convert varchar to int in sqlite
SQL
1 vote156 views1 answer
Drush sql-dump
SQL
1 vote155 views3 answers
Get all tables postgres
SQL
3 votes157 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL