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