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 26
| CREATE TABLE [dbo].[mvtFabr](
[pt_num] [varchar](18) NOT NULL,
[mf_dmvtdeb] [datetime] NOT NULL,
[ni_num] [varchar](23) NOT NULL,
[mf_trans] [varchar](25) NULL,
[pr_num] [int] NULL,
[pl_badge] [int] NULL,
[mf_statut] [varchar](5) NULL,
[mf_dmvtfin] [datetime] NULL,
[mf_duree] [float] NULL,
[mf_obs] [varchar](78) NULL,
[mf_seq] [int] NULL,
[of_num] [varchar](8) NULL,
[ge_phase] [int] NULL,
[mf_qte] [real] NULL,
[qc_code] [varchar](10) NULL,
[qd_id] [int] NULL,
PRIMARY KEY NONCLUSTERED
(
[pt_num] ASC,
[mf_dmvtdeb] ASC,
[ni_num] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90)
)
GO |
Partager