sql queries

#1 August 18th, 2008, 10:55 AM

i made a table and there is a column name departmentid(this is the
primary key) and there is one another column name department name... i
want that this column should not accept the same value... i mean to
say that every row in this column should be unique. how can i do
this.......

#2 August 18th, 2008, 01:05 PM

This is done by creating a UNIQUE constraint on department_name

CREATE TABLE Departments
(department_id NOT NULL PRIMARY KEY,
department_name NOT NULL UNIQUE)

brgds

Philipp Post

#3 August 18th, 2008, 01:15 PM

well, and do not forget the datatype:

CREATE TABLE Departments
(department_id INTEGER NOT NULL PRIMARY KEY,
department_name VARCHAR(30) NOT NULL UNIQUE)

brgds

Philipp POst

sql queries

re: sql queries

re: sql queries

/bytes/development

/bytes/it

/bytes/about