FirebirdSQL logo

SHOW PACKages

Added in

Firebird 3.0

SHOW PACKages [name]

This command lists all user-defined packages in the current database if the first form is used, or drills down to display the definition of the package.

SQL> show packages;
TEST

SQL> show package test;
TEST
Header source:
BEGIN
  PROCEDURE P1(I INT) RETURNS (O INT); -- public procedure
END

Body source:
BEGIN
  FUNCTION F1(I INT) RETURNS INT; -- private function
  PROCEDURE P1(I INT) RETURNS (O INT)
  AS
  BEGIN
  END
  FUNCTION F1(I INT) RETURNS INT
  AS
  BEGIN
    RETURN 0;
  END
END

SHOW PUBlications

Added in

Firebird 5.0

SHOW PUBlications [name]

This command lists all user-defined publications in the current database if the first form is used, or drills down to display the definition of the publication.

Currently, Firebird only has one system-defined publication, RDB$DEFAULT, and no option to create user-defined publications, so the output of show publications is always the same:

SQL> show publications;
There is no publications in this database

SQL> show system publications;
RDB$DEFAULT

SQL> show publication rdb$default;
RDB$DEFAULT: Disabled

SHOW ROLEs

SHOW ROLEs [name]

This command lists all roles in the current database if the first form is used, or drills down to display a list of all users who have been granted a specific role if the second form of the command is used.

SQL> show roles;
DEFAULT_USER

SQL> show role default_user;
Role DEFAULT_USER is granted to:
SYSDBA

SHOW SECCLAsses

SHOW SECCLAsses object_name

This command displays details about the security classes for a given object.The object_name passed to the command need not be a table name, the command works for tables, procedures, etc.

SQL> show secclasses employee;
Table's main sec class SQL$466
Table's default sec class SQL$DEFAULT58