Samuele E. Locatelli
9 lines
361 B
Transact-SQL
9 lines
361 B
Transact-SQL
CREATE TABLE [dbo].[PickList] (
|
|
[CodList] NVARCHAR (50) NOT NULL,
|
|
[Value] NVARCHAR (50) NOT NULL,
|
|
[Lemma] NVARCHAR (50) CONSTRAINT [DF_PickList_lemma] DEFAULT ('') NOT NULL,
|
|
[NumOrd] INT CONSTRAINT [DF_PickList_NumOrd] DEFAULT ((0)) NOT NULL,
|
|
CONSTRAINT [PK_PickList] PRIMARY KEY CLUSTERED ([CodList] ASC, [Value] ASC)
|
|
);
|
|
|