|
The SYSINFO view indicates the database characteristics, as defined when the database was created. It always contains only one row. This view is obtainable via built-in functions and is not kept in the catalog. Following is the definition for the SYSINFO view:
ALTER VIEW "SYS"."SYSINFO"( page_size,
encryption,
blank_padding,
case_sensitivity,
default_collation,
database_version)
as select db_property('PageSize'),if
db_property('Encryption') <> 'None' then 'Y'
else 'N'
endif,if db_property('BlankPadding') = 'On' then 'Y'
else 'N'
endif,if db_property('CaseSensitive') = 'On' then 'Y'
else 'N'
endif,db_property('Collation'),
null