Samuele E. Locatelli
10 lines
334 B
Transact-SQL
10 lines
334 B
Transact-SQL
CREATE TABLE [dbo].[ListValues] (
|
|
[TableName] NVARCHAR (50) NOT NULL,
|
|
[FieldName] NVARCHAR (50) NOT NULL,
|
|
[value] NVARCHAR (10) NOT NULL,
|
|
[label] NVARCHAR (50) NULL,
|
|
[ordinal] INT NULL,
|
|
CONSTRAINT [PK_ListValues] PRIMARY KEY CLUSTERED ([TableName] ASC, [FieldName] ASC, [value] ASC)
|
|
);
|
|
|