Samuele Locatelli
13 lines
336 B
Transact-SQL
13 lines
336 B
Transact-SQL
CREATE TABLE [As400].[t_CQNOC98L] (
|
|
[NumDocRNC] CHAR (10) NOT NULL,
|
|
[TipoInterv] CHAR (2) NOT NULL,
|
|
[CodArticolo] CHAR (15) NOT NULL,
|
|
[MatrPezzo] CHAR (15) NOT NULL
|
|
);
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [i_update]
|
|
ON [As400].[t_CQNOC98L]([NumDocRNC] ASC, [TipoInterv] ASC, [CodArticolo] ASC, [MatrPezzo] ASC);
|
|
|