The catalog component of the dictionary comprises SYSTEM tables. SYSTEM tables contain logical definition information for a database defined with SQL DDL and information on the definition of the physical implementation of the database.
SYSCA views are views defined on a subset of SYSTEM tables. SYSCA views restrict information that the user can select from SYSTEM tables to data about tables for which the user holds SELECT privilege.
Important: SYSTEM tables are defined in segment SYSCAT. This segment is created as part of defining the SYSTEM schema. SYSCAT should not be used as a segment name, and no attempt should be made to alter or delete the SYSCAT segment definition.
|
Copyright © 2014 CA.
All rights reserved.
|
|