SQLite
SQLite
  • 请登录查看
字典 我要纠错

SQLite Keywords

SQL As Understood By SQLite

[Top]

SQLite Keywords

The SQL standard specifies a huge number of keywords which may not be used as the names of tables, indices, columns, databases, user-defined functions, collations, virtual table modules, or any other named object- The list of keywords is so long that few people can remember them all- For most SQL code, your safest bet is to never use any English language word as the name of a user-defined object-

If you want to use a keyword as a name, you need to quote it- There are four ways of quoting keywords in SQLite:

   'keyword'
 A keyword in single quotes is a string literal.
  "keyword"
 A keyword in double-quotes is an identifier.
  [keyword]
 A keyword enclosed in square brackets is an identifier. This is not standard SQL. This quoting mechanism is used by MS Access and SQL Server and is included in SQLite for compatibility.