📄 sql-92.bnf.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><html><head><meta http-equiv="content-type" content="text/html; charset=gb2312"><!-- Generated HTML - Modify at your own peril! --><title> BNF Grammar for ISO/IEC 9075:1992 - Database Language SQL (SQL-92) </title></head><body><h1> BNF Grammar for ISO/IEC 9075:1992 - Database Language SQL (SQL-92) </h1><a name="top"> </a><br><a href="#xref-rules"> Cross-Reference: rules </a><br><a href="#xref-keywords"> Cross-Reference: keywords </a><br><p><font color="green"><i><small>Derived from file sql-92.bnf version 2.3 dated 2004/03/31 19:34:09<br>Generated on 2005-07-13 18:32:46+00:00 by file bnf2html.pl version 3.7 dated 2005/07/13 18:32:35</small></i></font></p><p>Using Appendix G of "Understanding the New SQL: A Complete Guide" by JMelton and A R Simon (Morgan Kaufmann, 1993, ISBN 0-55860-245-3) as thesource of the syntax, here is (most of) the BNF syntax for SQL-92. Themissing parts are the Cobol, Fortran, MUMPS, Pascal and PL/I variabledefinition rules.</p><p>The plain text version of this grammar is<a href="http://savage.net.au/SQL/sql-92.bnf"> sql-92.bnf </a>.</p><hr><h2> Key SQL Statements and Fragments</h2><bl><li> ALLOCATE CURSOR <a href="#allocate%20cursor%20statement"><allocate cursor statement></a></li><li> ALTER DOMAIN <a href="#alter%20domain%20statement"><alter domain statement></a></li><li> ALTER TABLE <a href="#alter%20table%20statement"><alter table statement></a></li><li> CLOSE cursor <a href="#close%20statement"><close statement></a> <a href="#dynamic%20close%20statement"><dynamic close statement></a></li><li> Column definition <a href="#column%20definition"><column definition></a></li><li> COMMIT WORK <a href="#commit%20statement"><commit statement></a></li><li> CONNECT <a href="#connect%20statement"><connect statement></a></li><li> CREATE ASSERTION <a href="#assertion%20definition"><assertion definition></a></li><li> CREATE CHARACTER SET <a href="#character%20set%20definition"><character set definition></a></li><li> CREATE COLLATION <a href="#collation%20definition"><collation definition></a></li><li> CREATE DOMAIN <a href="#domain%20definition"><domain definition></a></li><li> CREATE SCHEMA <a href="#schema%20definition"><schema definition></a></li><li> CREATE TABLE <a href="#table%20definition"><table definition></a></li><li> CREATE TRANSLATION <a href="#translation%20definition"><translation definition></a></li><li> CREATE VIEW <a href="#view%20definition"><view definition></a></li><li> Data type <a href="#data%20type"><data type></a></li><li> DEALLOCATE PREPARE <a href="#deallocate%20prepared%20statement"><deallocate prepared statement></a></li><li> DECLARE cursor <a href="#declare%20cursor"><declare cursor></a> <a href="#dynamic%20declare%20cursor"><dynamic declare cursor></a></li><li> DECLARE LOCAL TEMPORARY TABLE <a href="#temporary%20table%20declaration"><temporary table declaration></a></li><li> DELETE <a href="#delete%20statement:%20positioned"><delete statement: positioned></a> <a href="#delete%20statement:%20searched"><delete statement: searched></a> <a href="#dynamic%20delete%20statement:%20positioned"><dynamic delete statement: positioned></a></li><li> DESCRIBE <a href="#describe%20statement"><describe statement></a></li><li> DESCRIPTOR statements <a href="#system%20descriptor%20statement"><system descriptor statement></a></li><li> DISCONNECT <a href="#disconnect%20statement"><disconnect statement></a></li><li> EXECUTE <a href="#execute%20statement"><execute statement></a></li><li> EXECUTE IMMEDIATE <a href="#execute%20immediate%20statement"><execute immediate statement></a></li><li> FETCH cursor <a href="#fetch%20statement"><fetch statement></a> <a href="#dynamic%20fetch%20statement"><dynamic fetch statement></a></li><li> GET DIAGNOSTICS <a href="#get%20diagnostics%20statement"><get diagnostics statement></a></li><li> GRANT <a href="#grant%20statement"><grant statement></a></li><li> INSERT <a href="#insert%20statement"><insert statement></a></li><li> Literal <a href="#literal"><literal></a></li><li> MODULE <a href="#module"><module></a></li><li> OPEN cursor <a href="#open%20statement"><open statement></a> <a href="#dynamic%20open%20statement"><dynamic open statement></a></li><li> PREPARE <a href="#prepare%20statement"><prepare statement></a></li><li> Preparable statement <a href="#preparable%20statement"><preparable statement></a></li><li> REVOKE <a href="#revoke%20statement"><revoke statement></a></li><li> ROLLBACK WORK <a href="#rollback%20statement"><rollback statement></a></li><li> Search condition <a href="#search%20condition"><search condition></a></li><li> SELECT <a href="#query%20specification"><query specification></a></li><li> SET CATALOG <a href="#set%20catalog%20statement"><set catalog statement></a></li><li> SET CONNECTION <a href="#set%20connection%20statement"><set connection statement></a></li><li> SET CONSTRAINTS <a href="#set%20constraints%20mode%20statement"><set constraints mode statement></a></li><li> SET NAMES <a href="#set%20names%20statement"><set names statement></a></li><li> SET SCHEMA <a href="#set%20schema%20statement"><set schema statement></a></li><li> SET SESSION AUTHORIZATION <a href="#set%20session%20authorization%20identifier%20statement"><set session authorization identifier statement></a></li><li> SET TIME ZONE <a href="#set%20local%20time%20zone%20statement"><set local time zone statement></a></li><li> SET TRANSACTION <a href="#set%20transaction%20statement"><set transaction statement></a></li><li> UPDATE <a href="#update%20statement:%20positioned"><update statement: positioned></a> <a href="#update%20statement:%20searched"><update statement: searched></a> <a href="#dynamic%20update%20statement:%20positioned"><dynamic update statement: positioned></a></li><li> Value expression <a href="#value%20expression"><value expression></a></li></bl><p><a href="#top">Top</a></p><hr><h2> Basic Definitions of Characters Used, Tokens, Symbols, Etc.</h2><p><a name="SQL terminal character"> </a><a href="#xref-SQL%20terminal%20character"> <SQL terminal character> </a> ::=<br> <a href="#SQL%20language%20character"><SQL language character></a><br> | <a href="#SQL%20embedded%20language%20character"><SQL embedded language character></a></p><p><a name="SQL language character"> </a>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -