1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
CREATE TABLE [dbo].[MATABLE](
[COD.E] [varchar](35) NOT NULL,
[ABREGE] [varchar](270) NULL,
[GROUPE] [varchar](35) NULL,
[ONGLET] [varchar](35) NULL,
[MARQUE] [varchar](25) NULL,
[REFFAB] [varchar](50) NULL,
[CAD] [bit] NOT NULL,
[CAT1] [varchar](40) NULL,
[CAT2] [varchar](40) NULL,
[CAT3] [varchar](40) NULL,
[CAT4] [varchar](40) NULL,
[CAT5] [varchar](40) NULL,
[FAM] [varchar](30) NULL,
[ASS] [bit] NOT NULL,
CONSTRAINT [PK_ARTICLE] PRIMARY KEY CLUSTERED
(
[C.ODE] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] |
Partager