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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
| CREATE TABLE [dbo].[Bilan] (
[id_sorg] int NULL,
[id_cpt] int NULL,
[bil_ct] decimal(38, 2) NULL,
[bil_mlt] decimal(38, 2) NULL,
[bil_typ] bit NULL,
[bil_annex] int NULL,
[dat_bil] datetime CONSTRAINT [DF__Bilan__dat_bil__233F2673] DEFAULT getdate() NULL,
[note] varchar(50) COLLATE Arabic_CI_AS NULL
)
ON [PRIMARY]
GO
EXEC sp_addextendedproperty 'MS_Description', N'0:Normal
1:Consolidé', 'schema', 'dbo', 'table', 'Bilan', 'column', 'bil_typ'
GO
CREATE NONCLUSTERED INDEX [Bilan_idx] ON [dbo].[Bilan]
([id_sorg])
WITH (
PAD_INDEX = OFF,
FILLFACTOR = 50,
DROP_EXISTING = OFF,
STATISTICS_NORECOMPUTE = OFF,
SORT_IN_TEMPDB = OFF,
ONLINE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [Bilan_idx2] ON [dbo].[Bilan]
([bil_annex])
WITH (
PAD_INDEX = OFF,
FILLFACTOR = 50,
DROP_EXISTING = OFF,
STATISTICS_NORECOMPUTE = OFF,
SORT_IN_TEMPDB = OFF,
ONLINE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
GO
ALTER INDEX [Bilan_idx2]
ON [dbo].[Bilan]
DISABLE
GO
CREATE TRIGGER [dbo].[BilanTrigger] ON [dbo].[Bilan]
WITH EXECUTE AS CALLER
FOR INSERT, UPDATE
AS
EXTERNAL NAME [SqlServerTrigger].[Triggers].[BilanTrigger]
GO
DISABLE TRIGGER [BilanTrigger] ON [dbo].[Bilan]
GO |
Partager