" /> Password <br /><input type="password" name="passwd" id="passwd" class="inputbox" size="18" alt="password" />
PDF

UNIQUE

MySQL:

1
2
3
4
5
6
7
8

CREATE TABLE Persons (
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
UNIQUE (P_Id)
)

SQL Server / Oracle / MS Access:

1
2
3
4
5
6
7

CREATE TABLE Persons (
P_Id int NOT NULL UNIQUE,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)

MySQL / SQL Server / Oracle / MS Access:

1
2
3
4
5
6
7
8

CREATE TABLE Persons (
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT  UNIQUE (P_Id,LastName)
)

MySQL / SQL Server / Oracle / MS Access:

1
2

ALTER TABLE Persons
ADD UNIQUE (P_Id)

MySQL / SQL Server / Oracle / MS Access:

1
2

ALTER TABLE Persons
ADD CONSTRAINT  UNIQUE (P_Id,LastName)

MySQL:

1
2

ALTER TABLE Persons
DROP INDEX

SQL Server / Oracle / MS Access:

1
2

ALTER TABLE Persons
DROP CONSTRAINT

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Advertisement
© 2009 ageent.ru.