转自:http://blog.csdn.net/ezdevelop/archive/2004/09/21/111666.aspx
记录一下自己开发ezSqliteAdmin时所掌握的SQLite资料。
SQLite内建语法表
| 结构定义 |
| CREATE TABLE | 创建新表。 语法: | sql-command ::= | CREATE [TEMP | TEMPORARY] TABLE table-name ( column-def [, column-def]* [, constraint]* ) | | sql-command ::= | CREATE [TEMP | TEMPORARY] TABLE [database-name.] table-name AS select-statement | | column-def ::= | name [type] [[CONSTRAINT name] column-constraint]* | | type ::= | typename<
| |