SQL语法分析.doc

数据定义语言 创建数据库语法 SQL Server CREATE DATABASE database_name [ ON [ filespec [ ,...n ] ] [ , filegroup [ ,...n ] ] ] [ LOG ON { filespec [ ,...n ] } ] [ COLLATE collation_name ] [ FOR LOAD | FOR ATTACH ] MySql CREATE DATABASE [IF NOT EXISTS] db_name [create_specification [, create_specification] ...] Oracle CREATE DATABASE [ database ] { USER SYS IDENTIFIED BY password | USER SYSTEM IDENTIFIED BY password | CONTROLFILE REUSE | MAXDATAFILES integer | MAXINSTANCES integer | CHARACTER SET charset | NATIONAL CHARACTER SET charset | SET DEFAULT { BIGFILE | SMALLFILE } TABLESPACE | database_logging_clauses | tablespace_clauses | set_time_zone_clause }... ; Sybase create database database_name [on {default | database_device} [= size] [, database_device [= size]]...] [log on database_device [= size] [, database_device [= size]]...] [with {override | default_location = pathname}] [for {load | proxy_update}] 目前支持 CREATE DATABASE db_name [忽略] 不支持 不支持Mysql ‘IF NOT EXIST’ 语法； 不支持Oracle ‘CREATE DATABASE [db_name]’ 语法； 状态图 创建表语法 SQL Server CREATE TABLE [ database_name.[ owner ] .| owner.] table_name ( { column_definition | column_name AS computed_column_expression | table_constraint ::= [ CONSTRAINT constraint_name ] } | [ { PRIMARY KEY | UNIQUE } [ ,...n ] ) [ ON { filegroup | DEFAULT } ] [ TEXTIMAGE_ON { filegroup | DEFAULT } ] MySql CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_statement] Or: CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(] LIKE old_tbl_name [)]; Oracle CREATE [ GLOBAL TEMPORARY ] TABLE [ schema. ]table [ (relational_properties) ] [ ON COMMIT { DELETE | PRESERVE } ROWS ] [ physical_properties ] [ table_properties ] ; 或者 CREATE [ GLOBAL TEMPORARY ] TABLE [ schema. ]table OF [ schema. ]object_type [ object_table_substitution ] [ (object_properties) ] [ ON COMMIT { DELETE