|
|
SHOW commands are used to display metadata, including tables, indexes, procedures, triggers, and privileges. They can list the names of all objects of the specified type or supply detailed information about a particular object named in the command.
The SHOW commands are (approximately) the interactive equivalent of the command-line –extract, –x , or –a option (see “Extracting Metadata”). However, although you can use the OUTPUT command to send the output of the SHOW commands to a file, the saved text is not ready to use as a schema script without editing. Use the command- line options if obtaining a schema script is your goal.
Each SHOW command runs in its own READ COMMITTED statement, ensuring that each call returns the most up-to-date view of the state of the database.
SHOW CHECK
displays the names and sources for all user-defined CHECK constraints defined for a specified table.
SQL> SHOW CHECK tablename ; Tablename Name of a table that exists in the attached databaseExample:
...SHOW DATABASE displays information about the attached database (file name, page size and allocation, sweep interval, transaction numbers, Forced Writes status, default character set). SHOW DB is a shorthand version of the command.
SQL> SHOW DATABASE | DB ;SHOW DATABASE takes no arguments. Figure shows the output you can expect from SHOW DATABASE.
SHOW DATABASE output
For version and on-disk structure information, use SHOW VERSION.
SHOW DOMAIN[S]
displays domain information.
SQL> SHOW { DOMAINS | DOMAIN name };
Examples:
SQL> SHOW DOMAINS ;SHOW EXCEPTION[S] displays exception information.
SQL> SHOW { EXCEPTIONS | EXCEPTION name };
Examples:
...SHOW FUNCTION[S]
displays information about external functions declared in the attached database.
SQL> SHOW { FUNCTIONS | FUNCTION name };
Examples:
...SHOW GENERATOR[S] displays information about generators declared in the attached database.
SQL> SHOW { GENERATORS | GENERATOR name };
Examples:
...SHOW GRANT
displays privileges and role ownership information about a named object in the attached database or displays user membership within roles.
SQL> SHOW GRANT { object | rolename };
Examples:
...SHOW INDEX (SHOW INDICES) displays information about a named index, about indices for a specified table, or about indices for all tables in the attached database. The command can be abbreviated to SHOW IND.
SQL> SHOW {INDICES | INDEX { index | table }};Examples:
...SHOW PROCEDURE[S]
lists all procedures in the attached database, with their dependencies, or displays the text of the named procedure with the declarations and types (input/output) of any arguments. The command can be abbreviated to SHOW PROC.
SQL> SHOW {PROCEDURES | PROCEDURE name } ;
Examples:
SQL> SHOW PROCEDURES ;SHOW ROLE[S]
displays the names of SQL roles for the attached database.
SQL> SHOW ROLES ;SHOW ROLES takes no arguments.
Examples:
...To show user membership within roles, use SHOW GRANT rolename.
SHOW SQL DIALECT displays the SQL dialects of the client and of the attached database, if there is one.
SQL> SHOW SQL DIALECT;Example:
...SHOW SYSTEM displays the names of system tables and system views for the attached database. It can be abbreviated to SHOW SYS.
SQL> SHOW SYS [ TABLES ] ;The command takes no arguments. TABLES is an optional keyword that does not affect the behavior of the command.
Examples:
...SHOW TABLE[S]
lists all tables or views, or displays information about the named table or view.
SQL> SHOW { TABLES | TABLE name };
Examples:
...See also SHOW VIEWS (later in the chapter).
SHOW TRIGGER[S] displays all triggers defined in the database, along with the table they depend on or, for the named trigger, displays its sequence, type, activity status (active/inactive), and PSQL definition. It can be abbreviated to SHOW TRIG.
SQL> SHOW {TRIGGERS | TRIGGER name } ;
Examples:
SQL> SHOW TRIGGERS ;SHOW VERSION displays information about the software versions of isql and the Firebird server program, and the on-disk structure of the attached database. It can be abbreviated to SHOW VER.
SQL> SHOW VERSION ;The command takes no arguments. Example, from a server named “dev” running Firebird 1.5 on Windows 2000:
...SHOW VIEW[S] lists all views, or displays information about the named view. (See also SHOW TABLES.)
SQL> SHOW { VIEWS | VIEW name } ;
Example:
SQL> SHOW VIEWS ;
|
|
Firebird Related Tutorials |
|
---|---|
MySQL Tutorial | Linux Tutorial |
Windows 10 Tutorial | Windows 10 Development Tutorial |
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.