Samuele Locatelli
13 lines
430 B
Transact-SQL
13 lines
430 B
Transact-SQL
CREATE TABLE [dbo].[RelazUDC] (
|
|
[UDC_parent] NVARCHAR (50) NOT NULL,
|
|
[UDC_child] NVARCHAR (50) NOT NULL,
|
|
[dataMod] DATETIME CONSTRAINT [DF_RelazUDC_dataMod] DEFAULT (getdate()) NULL,
|
|
CONSTRAINT [PK_RelazUDC] PRIMARY KEY CLUSTERED ([UDC_parent] ASC, [UDC_child] ASC) WITH (FILLFACTOR = 95)
|
|
);
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [i_childUDC]
|
|
ON [dbo].[RelazUDC]([UDC_child] ASC) WITH (FILLFACTOR = 95);
|
|
|