ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table constraints |
|---|---|---|---|
| page_size | INTEGER | NOT NULL | |
| encryption | CHAR(1) | NOT NULL | |
| blank_padding | CHAR(1) | NOT NULL | |
| case_sensitivity | CHAR(1) | NOT NULL | |
| default_collation | CHAR(10) | ||
| database_version | SMALLINT | NOT NULL | |
| classes_version | CHAR(10) |
This table indicates the database characteristics, as defined when the database was created. It always contains only one row.
page_size The page size specified, in bytes. The default value is 1024.
encryption (Y/N) Indicates whether the -e switch was used with DBINIT.
blank_padding (Y/N) Indicates whether the database was created to use blank padding for string comparisons in the database ( -b switch was used with dbinit).
case_sensitivity (Y/N) Indicates whether the database is created as case sensitive. Case sensitivity affects value comparisons, but not table and column name comparisons. For example, if a database is case sensitive, table names such as SYSCATALOG can be specified in either case, but in a case-sensitive database 'abc' = 'ABC' is not true.
default_collation A string corresponding to the collation_label in SYSCOLLATE, which also corresponds to the collation sequence specified with DBINIT. The default value corresponds to the multilingual collation sequence (code page 850), which was the default prior to Watcom SQL 3.2. The collation sequence is used for all string comparisons, including searches for character strings as well as column and table name comparison.
database_version A small integer value indicating the database format. As newer versions become available, new features may require that the format of the database file change. The version number Adaptive Server Anywhere software to determine if this database was created with a newer version of the software and thus, cannot be understood by the software in use.
classes_version A small string describing the current version of the SYS.JAVA.CLASSES library that is currently installed on your computer.