SYSINFO system table
1016
SYSINFO system table
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.
To Next Page
Loading...