Samuele Locatelli
17 lines
553 B
Transact-SQL
17 lines
553 B
Transact-SQL
CREATE TABLE [dbo].[AS400_BatchConsumoMP] (
|
|
[ProgUDC] CHAR (10) NOT NULL,
|
|
[UDC] NVARCHAR (50) NOT NULL,
|
|
[DataPrelFus] NUMERIC (8) NOT NULL,
|
|
[TurnoPrelFus] NVARCHAR (50) NOT NULL,
|
|
[DestLega] NVARCHAR (50) NULL,
|
|
[DestTerz] NVARCHAR (50) NULL,
|
|
[DataInvioAs] DATETIME NULL,
|
|
CONSTRAINT [PK_AS400_BatchPrelievoMP] PRIMARY KEY CLUSTERED ([ProgUDC] ASC) WITH (FILLFACTOR = 95)
|
|
);
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [i_UDC]
|
|
ON [dbo].[AS400_BatchConsumoMP]([UDC] ASC) WITH (FILLFACTOR = 95);
|
|
|