Samuele Locatelli
21 lines
575 B
Transact-SQL
21 lines
575 B
Transact-SQL
CREATE TABLE [As400].[t_XOGIX00F] (
|
|
[XRPQLN] NUMERIC (6) NOT NULL,
|
|
[XRPQLD] NUMERIC (8) NOT NULL,
|
|
[XNRETI] CHAR (10) NOT NULL,
|
|
[XCDFOR] CHAR (6) NOT NULL,
|
|
[XCDTER] CHAR (6) NOT NULL,
|
|
[XCDPAR] CHAR (15) NOT NULL,
|
|
[XDTPRO] NUMERIC (8) NOT NULL,
|
|
[XTRPRO] CHAR (5) NOT NULL,
|
|
[XQTPRO] NUMERIC (5) NOT NULL,
|
|
[XDESMT] CHAR (3) NOT NULL,
|
|
[XMATSC] CHAR (1) NOT NULL,
|
|
[XBENQL] CHAR (1) NOT NULL
|
|
);
|
|
|
|
|
|
GO
|
|
CREATE NONCLUSTERED INDEX [i_update]
|
|
ON [As400].[t_XOGIX00F]([XRPQLN] ASC, [XRPQLD] ASC, [XNRETI] ASC);
|
|
|