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; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |