翻译文献APPENDIX A SQL Reference.docVIP

大连交通大学2016届本科生毕业设计（论文）外文翻译 -1- 大连交通大学2016届本科生毕业设计（论文）外文翻译 APPENDIX A SQL Reference The SQLite library understands most of the standard SQL language. But it does omit some features while at the same time adding a few features of its own. This reference is an overview of the SQL syntax implemented by SQLite, taken directly from the original documentation on the SQLite website (/lang.html) and slightly edited. Many low-level productions are omitted. For detailed information on the language that SQLite understands, refer to the source code and the grammar file parse.y in the source distribution. In all of the syntax diagrams that follow, literal text is shown in bold. Nonterminal symbols are shown in italic. Operators that are part of the syntactic markup itself are shown as regular. ALTER TABLE sql-statement ::= ALTER TABLE [database-name .] table-name alteration alteration ::= RENAME TO new-table-name alteration ::= ADD [COLUMN] column-def SQLite’s version of the ALTER TABLE command allows the user to rename or add a new column to an existing table. It is not possible to remove a column from a table. ATTACH DATABASE sql-statement ::= ATTACH [DATABASE] database-filename AS database-name The ATTACH DATABASE statement adds a preexisting database file to the current database connection. If the filename contains punctuation characters it must be quoted. The names “main” and “temp” refer to the main database and the database used for temporary tables. These cannot be detached. Attached databases are removed using the DETACH DATABASE statement. You can read from and write to an attached database and you can modify the schema of the attached database. This is a new feature of SQLite version 3.0. In SQLite 2.8, schema changes to attached databases were not allowed. You can not create a new table with the same name as a table in an attached database, but you can attach a database that contains tables whose names are duplicates of table