SHOW SEQuences
The Firebird specific name, generator, has been updated to match the SQL standard term sequence.The show sequences
command is identical to [isql-show-generators] (above) and the output is identical.
SHOW SEQuences
The Firebird specific name, generator, has been updated to match the SQL standard term sequence.The show sequences
command is identical to [isql-show-generators] (above) and the output is identical.
SHOW SYStem
SHOW SYStem [<object_type>] <object_type> :: = { TABLEs | COLLATIONs | COLLATEs | ROLEs | FUNCtions | PROCedures | PACKages | PUBLications }
This command lists the internal, i.e. system, objects created and used in the current database.The optional parameter restricts the listing to show only the specified object type.This applies from Firebird 2.0 onwards.Prior to version 2.0, the command would only list the system tables — equivalent to the show system tables
command.
If no parameter is passed, the listing will display tables, functions (not built-in functions though), collations, roles, procedures, packages, and publications.
Types PROCedures
, PACKages
and PUBLications
are available since Firebird 5.0.
SQL> show system; Tables: MON$ATTACHMENTS ... Functions: RDB$BLOB_UTIL.IS_WRITABLE ... Procedures: RDB$BLOB_UTIL.CANCEL_BLOB ... Packages: RDB$BLOB_UTIL ... Collations: ASCII ... Roles: RDB$ADMIN Publications: RDB$DEFAULT
Note that packaged procedures and functions are listed as <package-name>.<routine-name>
.
The show system <object_type>
can sometimes show more details compared to just show system
:
SQL> show system collations; ASCII, CHARACTER SET ASCII, PAD SPACE, SYSTEM ... WIN_PTBR, CHARACTER SET WIN1252, PAD SPACE, CASE INSENSITIVE, ACCENT INSENSITIVE, SYSTEM
If you wish to drill down and display details of a specific object, use the corresponding show <object-type> name
command, without system
.
SQL> show table mon$io_stats; MON$STAT_ID (RDB$STAT_ID) INTEGER Nullable MON$STAT_GROUP (RDB$STAT_GROUP) SMALLINT Nullable MON$PAGE_READS (RDB$COUNTER) BIGINT Nullable MON$PAGE_WRITES (RDB$COUNTER) BIGINT Nullable MON$PAGE_FETCHES (RDB$COUNTER) BIGINT Nullable MON$PAGE_MARKS (RDB$COUNTER) BIGINT Nullable SQL> show collation ascii; ASCII, CHARACTER SET ASCII, PAD SPACE, SYSTEM
SHOW SCHEmas
Firebird 3.0
SHOW SCHEmas
This command always returns an error.
SQL> show schemas; Command error: show schemas