UNIQUE but not PRIMARY

[anselme]

Hello
for MS SQL 2000 I want to CREATE a Table as follow :

CREATE TABLE [dbo].[Local] (
[id_Local] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar] (100) NOT NULL,
[Info] [nvarchar] (100) NULL
)


id_Local is PrimaryKey autoincrement
but Name must be UNIQUE (not 2 times the same name)

how can script it ?

thank you

[NitinKhurana]

CREATE UNIQUE INDEX Index1 ON TABLE (Name );

[rmiao]

Or:

CREATE TABLE [dbo].[Local] (
[id_Local] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar] (100) NOT NULL
UNIQUE NONCLUSTERED,
[Info] [nvarchar] (100) NULL
)

[anselme]

thank you

i try at once