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]
--------------------------------------------------------------------------
drop table if exists`District`;
CREATE TABLE [dbo].[District](
[Id] [int] NULL,
[CityId] [int] NULL,
[Name] [varchar](50) NULL,
[PostCode] [varchar](50) NULL
) ON [PRIMARY]
--------------------------------------------------------------------------
drop table if exists`City`;
CREATE TABLE [dbo].[City](
[Id] [int] NULL,
[ProvinceId] [int] NULL,
[Name] [varchar](50) NULL,
[AreaCode] [varchar](50) NULL
) ON [PRIMARY]
--------------------------------------------------------------------------
drop table if exists`tb_Change_event_typeID_table`;
CREATE TABLE [dbo].[tb_Change_event_typeID_table](
[change_event_typeID] [smallint] NOT NULL,
[change_event_content] [nvarchar](20) NULL,
CONSTRAINT [UQ__tb_Change_event___00551192] UNIQUE NONCLUSTERED
(
[change_event_typeID] 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`TAB_OMIN_CM_CC_NET`;
CREATE TABLE [dbo].[TAB_OMIN_CM_CC_NET](
[C_NET_ID] [varchar](36) NOT NULL,
[C_NETNAME] [varchar](50) NOT NULL,
[C_NETCODE] [varchar](2) NULL,
[C_NETVALUE] [varchar](50) NULL,
[C_PARENTID] [varchar](36) NULL,
[C_DESC] [varchar](1000) NULL
) ON [PRIMARY]
--------------------------------------------------------------------------
drop table if exists`Province`;
CREATE TABLE [dbo].[Province](
[Id] [int] NULL,
[Name] [varchar](50) NULL,
[codeID] [nchar](4) NULL
) ON [PRIMARY]
--------------------------------------------------------------------------
drop table if exists`tb_observation_element_code`;
CREATE TABLE [dbo].[tb_observation_element_code](
[elementId] [int] IDENTITY(1,1) NOT NULL,
[elementName] [varchar](30) NULL,
[subElementName] [varchar](50) NULL,
[DisplayElement] [nchar](1) NULL,
[orderID] [int] NULL
) ON [PRIMARY]
--------------------------------------------------------------------------
drop table if exists`tb_note_general_type_event_table`;
CREATE TABLE [dbo].[tb_note_general_type_event_table](
[note_general_event_typeID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
[note_general_event_name] [nvarchar](200) NULL,
CONSTRAINT [UQ__tb_note_general___7C8480AE] UNIQUE NONCLUSTERED
(
[note_general_event_typeID] 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_positon_table`;
CREATE TABLE [dbo].[tb_positon_table](
[positionname] [char](3) NOT NULL,
[orderID] [int] NOT NULL
) ON [PRIMARY]
--------------------------------------------------------------------------
drop table if exists`tb_responsibility_responsibility_code_table`;
CREATE TABLE [dbo].[tb_responsibility_responsibility_code_table](
[responsibleID] [varchar](3) NOT NULL,
[responsible_name] [nvarchar](10) NOT NULL,
CONSTRAINT [UQ__tb_responsibilit__07F6335A] UNIQUE NONCLUSTERED
(
[responsibleID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
sql
[解决办法]
mysql？你一部分一部分执行试试，没有环境
