SHOW SYSTEM
Go Up to isql Command Reference
Displays the names of system tables and system views for the current database.
SHOW SYSTEM [TABLES];
Description: SHOW SYSTEM
lists system tables and system views in the current database. SHOW
SYSTEM
accepts an optional keyword, TABLES
, which does not affect the behavior of the command.
SHOW SYSTEM
has a shorthand equivalent, SHOW SYS
.
Example: To list system tables and system views for the current database, enter:
SHOW SYS;
RDB$CHARACTER_SETS RDB$CHECK_CONSTRAINTS
RDB$COLLATIONS RDB$DATABASE
RDB$DEPENDENCIES RDB$EXCEPTIONS
RDB$FIELDS RDB$FIELD_DIMENSIONS
RDB$FILES RDB$FILTERS
RDB$FORMATS RDB$FUNCTIONS
RDB$FUNCTION_ARGUMENTS RDB$GENERATORS
RDB$INDEX_SEGMENTS RDB$INDICES
RDB$LOG_FILES RDB$PAGES
RDB$PROCEDURES RDB$PROCEDURE_PARAMETERS
RDB$REF_CONSTRAINTS RDB$RELATIONS
RDB$RELATION_CONSTRAINTS RDB$RELATION_FIELDS
RDB$ROLES RDB$SECURITY_CLASSES
RDB$TRANSACTIONS RDB$TRIGGERS
RDB$TRIGGER_MESSAGES RDB$TYPES
RDB$USER_PRIVILEGES RDB$VIEW_RELATIONS
See Also
For more information about system tables, see the Language Reference.