if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TBL_R0801_R2]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[TBL_R0801_R2] GO CREATE TABLE [dbo].[TBL_R0801_R2] ( [iden] [numeric](12, 0) NOT NULL , [FGroup] [char] (7) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL , [FYear] [int] NOT NULL , [FMonth] [int] NOT NULL , [FOrdCount] [int] NULL , [FOrdAmt] [decimal](9, 0) NULL , [FOrdBP] [decimal](9, 0) NULL , [FOrdQty] [decimal](9, 0) NULL ) ON [PRIMARY] GO