/SQL/Add primary key to database sql

Add primary key to database sql

Add primary key to existing table sql

alter table Persion add primary key (persionId,Pname,PMID)

7

Source: stackoverflow.com

Add primary key to existing table sql

ALTER TABLE `tblauto`
  ADD PRIMARY KEY (`id`);

--

0

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)
);

0

Similar codes

13 votes189 views6 answers
Current date sql
SQL
0 vote183 views1 answer
Show function mysql
SQL
2 votes184 views1 answer
Mysql select random id from table
SQL
1 vote197 views1 answer
Md5 encryption for existing records
SQL
0 vote240 views1 answer
Pl sql join 3 tables
SQL
1 vote189 views1 answer
Sql get missing id
SQL
4 votes187 views1 answer
Check database name postgresql
SQL
1 vote191 views1 answer
Oracle case
SQL
0 vote188 views1 answer
Mysql drop trigger
SQL
0 vote197 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL

Share