《sql语法分析》由会员分享,可在线阅读,更多相关《sql语法分析(22页珍藏版)》请在金锄头文库上搜索。
1、数据定义语言创建数据库语法SQL ServerCREATE DATABASE database_name ON ,.n , ,.n LOGON ,.n COLLATE collation_name FOR LOAD | FOR ATTACH MySqlCREATE DATABASE IF NOT EXISTS db_namecreate_specification , create_specification .OracleCREATE DATABASE database USER SYS IDENTIFIED BY password | USER SYSTEM IDENTIFIED BY p
2、assword | 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 . ;Sybasecreate database database_nameon default | da
3、tabase_device = size, database_device = size.log on database_device = size, database_device = size.with override | default_location = pathnamefor load | proxy_update目前支持CREATE DATABASE db_name 忽略不支持不支持Mysql IF NOT EXIST 语法;不支持Oracle CREATE DATABASE db_name 语法;状态图创建表语法SQL ServerCREATE TABLE database_
4、name. owner .| owner. table_name ( | column_name AS computed_column_expression | := CONSTRAINT constraint_name | PRIMARY KEY | UNIQUE ,.n ) ON filegroup | DEFAULT TEXTIMAGE_ON filegroup | DEFAULT MySqlCREATE TEMPORARY TABLE IF NOT EXISTS tbl_name (create_definition,.) table_options select_statementO
5、r: CREATE TEMPORARY TABLE IF NOT EXISTS tbl_name ( LIKE old_tbl_name );OracleCREATE 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_su
6、bstitution (object_properties) ON COMMIT DELETE | PRESERVE ROWS OID_clause OID_index_clause physical_properties table_properties ;或者CREATE TABLE GLOBAL TEMPORARY TABLE schema. table OF XMLTYPE (oject_properties) XMLTYPE XMLType_storage XMLSchema_spec ON COMMIT DELETE | PRESERVE ROWS OID_clause OID_i
7、ndex_clause physical_properties table_properties ;Sybasecreate table database.owner.table_name(column_name datatypedefault constant_expression | user | nullidentity | null | not nulloff row | in row| constraint constraint_nameunique | primary keyclustered | nonclustered asc | descwith fillfactor = p
8、ct| max_rows_per_page = num_rows , reservepagegap = num_pages on segment_name| references database.owner.ref_table(ref_column)| check (search_con ion).| constraint constraint_nameunique | primary keyclustered | nonclustered(column_name asc | desc, column_name asc | desc.)with fillfactor = pct| max_r
9、ows_per_page = num_rows ,reservepagegap = num_pages on segment_name|foreign key (column_name , column_name.)references database.owner.ref_table(ref_column , ref_column.)| check (search_con ion) . , next_column | next_constraint.)lock datarows | datapages | allpages with max_rows_per_page = num_rows
10、,exp_row_size = num_bytes ,reservepagegap = num_pages on segment_name external table at pathname SQL92CREATE GLOBAL | LOCAL TEMPORARY TABLE ON COMMIT DELETE | PRESERVE ROWS 目前支持CREATE GLOBAL | LOCAL TEMPORARY TABLE table_exp 忽略SQL Server / Sybase table_exp := database_name. owner .| owner. table_nam
11、eOracle table_exp := schema. table不支持不支持Mysql CREATE TEMPORARY TABLE IF NOT EXISTS tbl_name状态图创建视图语法SQL ServerCREATE VIEW . . view_name ( column ,.n ) WITH ,.n AS select_statement WITH CHECK OPTION MySqlOracleCREATE OR REPLACE NO FORCE VIEW schema. view (alias inline_constraint inline_constraint . |
12、 out_of_line_constraint, alias inline_constraint inline_constraint . | out_of_line_constraint.)| object_view_clause| XMLType_view_clauseAS subquery subquery_restriction_clause ;Sybasecreate view owner.view_name(column_name , column_name.)as select distinct select_statementwith check optionSQL92CREATE VIEW AS WITH CHECK OPTION 目前支持CREATE