Differences

This shows you the differences between two versions of the page.

--- database:sqlite [2015/12/28 03:16] – [sqlitepo] mnewnham
+++ v5:database:sqlite [2016/01/13 01:53] – ↷ Page moved from database:sqlite to v5:database:sqlite mnewnham
@@ Line 1: / Line 1: @@
 ===== SQLite Database =====
 ~~NOTOC~~
-==== sqlite3 ====
+===== sqlite3 =====
 <WRAP right box round 300px>
 == Specification ==
@@ Line 17: / Line 17: @@
 This preferred driver supports connections to SQLite version 3 databases.
+Note that SQLite table and index names are case-sensitive, but do not allow full case-sensitivity like the [[database:IBM DB2]] driver.
+==== Limitations in Meta Functions ====
+The driver does not support the following metaFunctions:
+  * [[dictionary:alterColumnSql()]]
+  * [[dictionary:dropColumnSql()]]
+This is a limitation of Sqlite itself, not ADOdb. For more information see [[http://www.sqlite.org/lang_altertable.html|Here]]
 {{tag>[sqlite3 active]}}
 -------------------------------
-==== sqlite ====
+===== sqlite =====
 <WRAP right box round 300px>
 == Specification ==
@@ Line 33: / Line 41: @@
 {{tag>[sqlite2 unix windows deprecated]}}
 ---------------------------------------------
-==== sqlitepo ====
+===== sqlitepo =====
 <WRAP right box round 300px>
 == Specification ==
@@ Line 47: / Line 55: @@
 This deprecated driver added portability to the sqlite2 driver by stripping the table names from the column names in queries. The Sqlite3 exhibits this behavior by default.
 {{tag>[sqlite2 deprecated]}}