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);