SHOW Statements Overview

SHOW statements provide information about databases, tables, columns, and other database objects in OmniFabric. This page lists all available SHOW statements.

Available SHOW Statements

Statement	Description
SHOW ACCOUNTS	Display information about accounts
SHOW COLLATION	Display available collations
SHOW COLUMNS	Display column information for tables
SHOW CREATE PUBLICATION	Display the CREATE statement for publications
SHOW CREATE TABLE	Display the CREATE statement for tables
SHOW CREATE VIEW	Display the CREATE statement for views
SHOW DATABASES	Display available databases
SHOW FUNCTION STATUS	Display function status information
SHOW GRANTS	Display privilege information for users
SHOW INDEX	Display index information for tables
SHOW PITRS	Display Point-in-Time Recovery information
SHOW PROCESSLIST	Display running processes
SHOW PUBLICATIONS	Display publication information
SHOW ROLES	Display role information
SHOW SEQUENCES	Display sequence information
SHOW STAGE	Display stage information
SHOW SUBSCRIPTIONS	Display subscription information
SHOW TABLES	Display tables in databases
SHOW VARIABLES	Display system variable values

Usage Pattern

Most SHOW statements follow this general pattern:

SHOW [statement_type] [FROM database_name] [WHERE condition] [LIKE 'pattern']

For specific syntax and examples, click on any statement above to view its detailed documentation.