-CREATE TABLE [SubSNPAcc_p1_human] (
- [subsnp_id] [int] NOT NULL ,
- [acc_type_ind] [char] (1) NOT NULL ,
- [acc_part] [varchar] (16) NOT NULL ,
- [acc_ver] [int] NULL
-)
+CREATE TABLE [SubSNPAcc_p1_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[acc_type_ind] [char](1) NOT NULL ,
+[acc_part] [varchar](16) NOT NULL ,
+[acc_ver] [int] NULL
+)\r
GO
-
-CREATE TABLE [SubSNPAcc_p2_human] (
- [subsnp_id] [int] NOT NULL ,
- [acc_type_ind] [char] (1) NOT NULL ,
- [acc_part] [varchar] (16) NOT NULL ,
- [acc_ver] [int] NULL
-)
+CREATE TABLE [SubSNPAcc_p2_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[acc_type_ind] [char](1) NOT NULL ,
+[acc_part] [varchar](16) NOT NULL ,
+[acc_ver] [int] NULL
+)\r
GO
-
-CREATE TABLE [SubSNPAcc_p3_human] (
- [subsnp_id] [int] NOT NULL ,
- [acc_type_ind] [char] (1) NOT NULL ,
- [acc_part] [varchar] (16) NOT NULL ,
- [acc_ver] [int] NULL
-)
+CREATE TABLE [SubSNPAcc_p3_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[acc_type_ind] [char](1) NOT NULL ,
+[acc_part] [varchar](16) NOT NULL ,
+[acc_ver] [int] NULL
+)\r
GO
-
-CREATE TABLE [SubSNPCommLine_p1_human] (
- [subsnp_id] [int] NOT NULL ,
- [line_num] [tinyint] NOT NULL ,
- [line] [varchar] (255) NOT NULL
-)
+CREATE TABLE [SubSNPCommLine_p1_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)\r
GO
-
-CREATE TABLE [SubSNPCommLine_p2_human] (
- [subsnp_id] [int] NOT NULL ,
- [line_num] [tinyint] NOT NULL ,
- [line] [varchar] (255) NOT NULL
-)
+CREATE TABLE [SubSNPCommLine_p2_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)\r
GO
-
-CREATE TABLE [SubSNPCommLine_p3_human] (
- [subsnp_id] [int] NOT NULL ,
- [line_num] [tinyint] NOT NULL ,
- [line] [varchar] (255) NOT NULL
-)
+CREATE TABLE [SubSNPCommLine_p3_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)\r
GO
-
-CREATE TABLE [SubSNPSeq3_p1_human] (
- [subsnp_id] [int] NOT NULL ,
- [type] [tinyint] NOT NULL ,
- [line_num] [tinyint] NOT NULL ,
- [line] [varchar] (255) NOT NULL
-)
+CREATE TABLE [SubSNPSeq3_p1_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[type] [tinyint] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)\r
GO
-
-CREATE TABLE [SubSNPSeq3_p2_human] (
- [subsnp_id] [int] NOT NULL ,
- [type] [tinyint] NOT NULL ,
- [line_num] [tinyint] NOT NULL ,
- [line] [varchar] (255) NOT NULL
-)
+CREATE TABLE [SubSNPSeq3_p2_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[type] [tinyint] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)\r
GO
-
-CREATE TABLE [SubSNPSeq3_p3_human] (
- [subsnp_id] [int] NOT NULL ,
- [type] [tinyint] NOT NULL ,
- [line_num] [tinyint] NOT NULL ,
- [line] [varchar] (255) NOT NULL
-)
+CREATE TABLE [SubSNPSeq3_p3_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[type] [tinyint] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)\r
GO
-
-CREATE TABLE [SubSNPSeq5_p1_human] (
- [subsnp_id] [int] NOT NULL ,
- [type] [tinyint] NOT NULL ,
- [line_num] [tinyint] NOT NULL ,
- [line] [varchar] (255) NOT NULL
-)
+CREATE TABLE [SubSNPSeq5_p1_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[type] [tinyint] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)\r
GO
-
-CREATE TABLE [SubSNPSeq5_p2_human] (
- [subsnp_id] [int] NOT NULL ,
- [type] [tinyint] NOT NULL ,
- [line_num] [tinyint] NOT NULL ,
- [line] [varchar] (255) NOT NULL
-)
+CREATE TABLE [SubSNPSeq5_p2_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[type] [tinyint] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)\r
GO
-
-CREATE TABLE [SubSNPSeq5_p3_human] (
- [subsnp_id] [int] NOT NULL ,
- [type] [tinyint] NOT NULL ,
- [line_num] [tinyint] NOT NULL ,
- [line] [varchar] (255) NOT NULL
-)
+CREATE TABLE [SubSNPSeq5_p3_human]
+(
+[subsnp_id] [int] NOT NULL ,
+[type] [tinyint] NOT NULL ,
+[line_num] [tinyint] NOT NULL ,
+[line] [varchar](255) NOT NULL
+)\r
GO
-
-CREATE TABLE [dn_table_rowcount] (
- [tabname] [varchar] (64) NOT NULL ,
- [row_cnt] [int] NOT NULL ,
- [build_id] [int] NOT NULL ,
- [update_time] [datetime] NOT NULL ,
- [rows_in_spaceused] [int] NULL ,
- [reserved_KB_spaceused] [int] NULL ,
- [data_KB_spaceused] [int] NULL ,
- [index_size_KB_spaceused] [int] NULL ,
- [unused_KB_spaceused] [int] NULL
-)
+CREATE TABLE [dn_table_rowcount]
+(
+[tabname] [varchar](64) NOT NULL ,
+[row_cnt] [int] NOT NULL ,
+[build_id] [int] NOT NULL ,
+[update_time] [datetime] NOT NULL ,
+[rows_in_spaceused] [int] NULL ,
+[reserved_KB_spaceused] [int] NULL ,
+[data_KB_spaceused] [int] NULL ,
+[index_size_KB_spaceused] [int] NULL ,
+[unused_KB_spaceused] [int] NULL
+)\r
GO
-