当前位置: 代码迷 >> Sql Server >> sql 脚本建表,该怎么处理
  详细解决方案

sql 脚本建表,该怎么处理

热度:43   发布时间:2016-04-24 19:53:10.0
sql 脚本建表

以下为代码,麻烦大哥大姐们看看是什么错误??、
--------------------------------------------------------------------------
drop  table  if exists`tb_metadata_information_summary`;
CREATE TABLE [dbo].[tb_metadata_information_summary](
[metadata_identifiers] [varchar](50) NOT NULL,
[station_file_number] [varchar](5) NULL,
[station_referred_chinese] [nvarchar](50) NOT NULL,
[station_referred_english] [varchar](50) NULL,
[longitude] [varchar](6) NULL,
[latitude] [varchar](5) NULL,
[station_altitude] [varchar](6) NULL,
[geographic_informationID] [varchar](50) NULL,
[geographic_environmentID] [varchar](50) NULL,
[detailed_address] [nvarchar](50) NULL,
[institutional_affiliation] [nvarchar](50) NULL,
[tiem_up] [varchar](20) NOT NULL,
[tieme_remove] [varchar](20) NULL,
[remove_station_num] [int] NULL,
[recent__moved_station_time] [varchar](20) NULL,
[metadata_update_time] [varchar](20) NOT NULL,
[others] [nvarchar](100) NULL,
[barometer_altitude] [bigint] NULL,
[ground_airport_altitude] [bigint] NULL,
[wind_speed_sensor_platform_height] [bigint] NULL,
[observation_platform_height] [bigint] NULL,
[WMORegionNumber] [varchar](6) NOT NULL,
[WMORegionName] [nvarchar](50) NOT NULL,
[countryAreaName] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK__tb_metadata_info__0CBAE877] PRIMARY KEY CLUSTERED 
(
[metadata_identifiers] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
--------------------------------------------------------------------------
drop  table  if exists`tb_metadata_information`;
CREATE TABLE [dbo].[tb_metadata_information](
[filedentifer] [varchar](36) NOT NULL,
[language] [varchar](50) NOT NULL,
[characterSet] [varchar](50) NOT NULL,
[dataStemp] [varchar](10) NOT NULL,
[metadataStandardName] [varchar](60) NULL,
[metadataStandardVersion] [varchar](60) NULL,
[contact] [varchar](5) NULL,
[metadata_identifiers] [varchar](50) NULL,
 CONSTRAINT [PK__tb_metadata_info__662B2B3B] PRIMARY KEY CLUSTERED 
(
[filedentifer] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
--------------------------------------------------------------------------
drop  table  if exists`tb_geographic_environment_code`;
CREATE TABLE [dbo].[tb_geographic_environment_code](
[geographic_environmentID] [char](3) NOT NULL,
[geographic_environment] [nvarchar](10) NOT NULL,
UNIQUE NONCLUSTERED 
(
[geographic_environmentID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
--------------------------------------------------------------------------
drop  table  if exists`tb_error_logging`;
CREATE TABLE [dbo].[tb_error_logging](
[metadata_identifiers] [varchar](50) NULL,
[wrong_line] [nvarchar](200) NULL,
[erroe_type] [nvarchar](50) NULL
) ON [PRIMARY]
--------------------------------------------------------------------------
drop  table  if exists`tb_check`;
CREATE TABLE [dbo].[tb_check](
[ID] [bigint] IDENTITY(1,1) NOT NULL,
[metadata_identifiers] [varchar](50) NULL,
[submitter] [varchar](20) NULL,
[submit_time] [varchar](20) NULL,
[assessor] [varchar](20) NULL,
[check_time] [varchar](20) NULL,
[state] [int] NULL,
[item] [char](10) NULL,
[item_option] [nchar](10) NULL,
[content] [nvarchar](500) NULL,
[change_time] [varchar](20) NULL,
[parentID] [bigint] NULL,
 CONSTRAINT [PK_tb_check] PRIMARY KEY CLUSTERED 
(
[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
--------------------------------------------------------------------------
drop  table  if exists`tb_character_code_table`;
CREATE TABLE [dbo].[tb_character_code_table](
[chinese_name] [varchar](50) NULL,
[english_name] [varchar](50) NULL,
[yu_identity] [varchar](3) NOT NULL,
[define] [varchar](50) NULL
) ON [PRIMARY]
  相关解决方案