SQlite not supported in SQL92

========================================================== ==================================

Title: not supported by SQLite in sql92

Date: 2011.4.20

Name: Zhu minglei

========================================================== ==================================

1Advanced connections: SQLite supports "left Outer Join" and does not support "right Outer Join" and "Full outer join )".

2Modify a table: SQLite supports "rename table" and "alter table" to add new columns to the table ". You cannot use "alter table" to "drop column", "alter column", or "add constraint.

3 Incomplete trigger support: SQLite supports "for each row" and does not support "for each statement )".

4Views can only be read and cannot be written: SQLite cannot use the "delete", "insert", and "Update" statements on a view. However, you can create a trigger to activate the trigger when performing "delete", "insert", or "Update" operations on the table, and perform the required operations in the body part of the trigger.

5GRANT not supportedAnd REVOKEStatement: Because SQlite only reads and writes common disk files, the only access permission (Control) that can be applied to the SQlite database is only the normal file access permission of the underlying operating system. Therefore, SQlite does not support the GRANT and REVOKE commands commonly used in databases in the client/server mode because they are meaningless to the "embedded database engine.

Original website address: Http://www.sqlite.org/omitted.html