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 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76
| USE [BaseTest]
GO
/****** Object: Table [dbo].[Table1] Script Date: 05/23/2013 14:20:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Table1](
[ifa] [numeric](15, 0) IDENTITY(1,1) NOT NULL,
[fd] [datetime] NULL,
[m] [money] NULL,
[ic] [numeric](15, 0) NOT NULL,
[e] [bit] NULL,
[m_accompte] [money] NULL,
[l_e] [bit] NULL,
[av_c] [varchar](80) NULL,
[id_employe] [int] NULL,
[num_fac] [numeric](15, 0) NULL,
[an] [bit] NULL,
[ap] [bit] NULL,
[t_f] [char](1) NULL,
[comment] [varchar](700) NULL,
[fact_ti] [varchar](50) NULL,
[fact_no] [varchar](50) NULL,
[fact_pr] [varchar](50) NULL,
[fact_cp] [varchar](20) NULL,
[fact_com] [varchar](40) NULL,
[livr_typ] [varchar](4) NULL,
[livr_cp] [varchar](20) NULL,
[livr_com] [varchar](40) NULL,
[livr_id_cp] [int] NULL,
[nbutil] [int] NOT NULL,
[if_ori] [numeric](15, 0) NULL,
[num_fac_orig] [varchar](20) NULL,
[type_av] [char](1) NULL,
[num_letr] [int] NULL,
CONSTRAINT [PK_Fa] PRIMARY KEY CLUSTERED
(
[ifa] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Table1] ADD CONSTRAINT [DF_Table1_fd] DEFAULT (getdate()) FOR [fd]
GO
ALTER TABLE [dbo].[Table1] ADD CONSTRAINT [DF_Table1_ic] DEFAULT (1) FOR [ic]
GO
ALTER TABLE [dbo].[Table1] ADD CONSTRAINT [DF_Table1_e] DEFAULT (0) FOR [e]
GO
ALTER TABLE [dbo].[Table1] ADD CONSTRAINT [DF_Table1_l_e] DEFAULT (0) FOR [l_e]
GO
ALTER TABLE [dbo].[Table1] ADD CONSTRAINT [DF_Table1_ap] DEFAULT (1) FOR [ap]
GO
ALTER TABLE [dbo].[Table1] ADD CONSTRAINT [DF_Table1_t_f] DEFAULT ('F') FOR [t_f]
GO
ALTER TABLE [dbo].[Table1] ADD CONSTRAINT [DF_Table1_fcp] DEFAULT (0) FOR [fcp]
GO |
Partager