SQLite - Admin Notes

There are currently the following limitations with the admin component for SQLite. Many of these limitations are due to the limited amount of information available in the SQLite system table (sqlite_master), or bugs/limitations of the SQLite ODBC Functions.

• constraint names (for Primary Key and Foreign Keys) are not displayed correctly.
  • DDL for tables will correctly have the correct constraint names
  • Properties / Alter and Redefine for table will not have the correct constraint name. AQT will generate names for these as (for the Primary Key) pk_tablename and (for Foreign Keys) fkn where n is an incrementing number.
• DDL for Descending Index columns are generated as Ascending columns.
• AQT has limited support for table Check Constraints. You are able to create a table with Check Constraint, however these will not be displayed when you display the table properties. The table DDL will include the check constraints.