/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

3 votes134 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote121 views1 answer
Restore backupfile discourse
SQL
0 vote87 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
5 votes125 views2 answers
Create table mysql example auto_increment
SQL
3 votes131 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
2 votes86 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote118 views1 answer
How to to get current date and time in sql
SQL
0 vote123 views1 answer
Postgres copy command
SQL
0 vote124 views1 answer
Sql create text column limited values
SQL
0 vote146 views1 answer
Sql last time database was accessed
SQL

Share