Create UNIQUE KEY

pradheepayyanar

hello
can anyone tell me how to create a table with 3 columns as UNIQUE KEY

PraDz

somaskarthic

hi

Try this

CREATE TABLE test1
(
id int4 NOT NULL,
field1 int4,
field2 int4,
field3 int4,
CONSTRAINT idpkey PRIMARY KEY (id),
CONSTRAINT field1unique1 UNIQUE (field1),
CONSTRAINT fieldunique2 UNIQUE (field2),
CONSTRAINT fieldunique3 UNIQUE (field3)
)

-somaskarthic

Quote:

Originally Posted by pradheepayyanar

hello
can anyone tell me how to create a table with 3 columns as UNIQUE KEY

PraDz

Create UNIQUE KEY

re: Create UNIQUE KEY

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about