UltraLite Database User's Guide
UltraLite Databases
UltraLite database limitations
The following Adaptive Server Anywhere features are not available in UltraLite databases:
Cascading updates and deletes Some applications rely on declarative referential integrity to implement business rules. These features are not available in UltraLite databases.
Check constraints You cannot include table or column check constraints in an UltraLite database.
Computed columns You cannot include computed columns in an UltraLite database.
Timestamp columns You cannot use Transact-SQL timestamp columns in UltraLite databases. Transact-SQL timestamp columns are created with the following default:
DEFAULT TIMESTAMP
You can use columns created as follows:
DEFAULT CURRENT TIMESTAMP
There is a behavior difference between the two: a DEFAULT CURRENT TIMESTAMP column is not automatically updated when the row is updated, while a DEFAULT TIMESTAMP column is automatically updated. You must explicitly update columns created with DEFAULT CURRENT TIMESTAMP if you wish the column to reflect the latest update time.
Global temporary tables The temporary aspect of global temporary tables is not recognized by UltraLite. They are treated as if they were permanent base tables, which you should use instead.
Declared temporary tables You cannot declare a temporary table within an UltraLite application.
Stored procedures You cannot call stored procedures or user-defined functions in an UltraLite application.
System table access There are no system tables in an UltraLite database.
SAVEPOINT statement UltraLite databases support transactions, but not savepoints within transactions.
SET OPTION statement You can determine the option settings in an UltraLite database by setting them in the reference database, but you cannot use the SET OPTION statement in an UltraLite application to change option settings.
System functions You cannot use Adaptive Server Anywhere system functions, including property functions, in UltraLite applications.
Functions Not all SQL functions are available for use in UltraLite applications. For example, the ISDATE and ISNUMERIC functions are not available for use in UltraLite databases.
Use of an unsupported function gives a Feature not available in UltraLite
error.
Triggers Triggers are not available in UltraLite databases.
Java in the database You cannot include Java methods in your queries or make any other use of Java in the database.
Schema modification To modify the schema of a UltraLite database, you must build a new version of your application.
For more information, see Schema changes in remote databases.
Limited dynamic SQL If you are using dynamic SQL in your UltraLite application, the range of SQL available is less than in Adaptive Server Anywhere.
For more information, see Dynamic SQL