1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
REATE TABLE [dbo].[T_DEVPART2_DPT](
[DPT_ID] [bigint] NOT NULL,
[DEV_ID] [bigint] NULL,
[DPT_PID] [bigint] NULL,
[DPT_ORD] [int] NULL,
[DPT_STYPE] [dbo].[D_SOUS_TYP_ELEMENT] NULL CONSTRAINT [DF_T_DEVPART_DPT_DPT_STYPE] DEFAULT ((1)),
[DPT_IMPR] [bit] NULL,
[DPT_FAMILLE] [dbo].[D_FAMILLE_ARTICLE] NULL,
[DPT_SFAMILLE] [dbo].[D_FAMILLE_ARTICLE] NULL,
CONSTRAINT [PK_T_DEVPART2_DPT] PRIMARY KEY CLUSTERED
(
[DPT_ID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
CREATE TABLE dbo.#DevisPartTmp(
ID BIGINT PRIMARY KEY,
PID BIGINT,
STYPE INT,
FAMILLE dbo.D_FAMILLE_ARTICLE,
SFAMILLE dbo.D_FAMILLE_ARTICLE
) |