日期:2014-05-17  浏览次数:20648 次

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 = O