SHOW --+-> show-params-1 --------------+--> +-> show-params-2 --------------+ +-> show-session-information ---+ show-params-1 = ----+-> show-aliases --------------+---> +-> show-cache ----------------+ +-> show-catalogs -------------+ +-> CHARACTER SETS ------------+ +-> show-collating-sequence ---+ +-> show-connections ----------+ +-> CURSORS -------------------+ +-> show-databases ------------+ +-> DISPLAY -------------------+ +-> show-domains --------------+ +-> FLAGS ---------------------+ +-> show-functions ------------+ +-> show-indexes --------------+ +-> show-journals -------------+ +-> show-modules --------------+ +-> show-outlines -------------+ show-params-2 = --+-> show-profiles -------------+-> +-> show-privileges -----------+ +-> show-procedures -----------+ +-> QUERY CONFIRM -------------+ +-> QUERY LIMIT ---------------+ +-> show-roles ----------------+ +-> show-schemas --------------+ +-> show-sequences ------------+ +-> show-storage-areas --------+ +-> show-storage-maps ---------+ +-> show-synonyms -------------+ +-> show-tables ---------------+ +-> show-triggers -------------+ +-> show-users ----------------+ +-> show-users-granting -------+ +-> show-users-with -----------+ +-> VARIABLES -----------------+ +-> show-views ----------------+ show-aliases = --> ALIASES --+----------------+--> +-+-> <alias> -+-+ | +----- , <---+ | +---> * ---------+ show-cache = ---> CACHE -+---------------------+--> +---> <name-list> ----+ show-catalogs = ---> CATALOGS --+-----------------+-> +-> name-list ----+ show-collating-sequence = ---> COLLATING SEQUENCE --+---------------+--> +-> name-list --+ show-connections = ---> CONNECTIONS -+-+---------------------+-+-> | +-> DEFAULT ----------+ | | +-> CURRENT ----------+ | | +-> <connection-name> + | +------------- , <--------+ show-databases = --> DATABASES --+----------------+--> +-+-> <alias> -+-+ | +----- , <---+ | +---> * ---------+ show-domains = -+-----------+-> DOMAINS -+---------------+--> +-> SYSTEM -+ +-> name-list --+ +-> ALL ----+ show-functions = -+------------+-> FUNCTIONS +-----------------------------+-+---------------+-> +-> SYSTEM -+ +> ( ++-> COMMENT -----++> ) -+ +-> name-list -+ +-> ALL -----+ |+-> ID ----------+| |+-> LANGUAGE ----+| |+-> MODULE ------+| |+-> OWNER -------+| |+-> PARAMETER ---+| |+-> SOURCE ------+| +------- , <-------+ show-indexes = -+-----------++-> INDEXES -+-+---------------------------------------+-> +-> SYSTEM -++-> INDICES -+ +-> ON -+> <table-name> ----------------+ +-> ALL ----+ | +----- , <----------------------+ +-> name-list --------------------------+ +-> ( -+-> CARDINALITY +> name-list ) -+ +-- PARTITIONS | +------- , ------+ show-journals ---> JOURNALS -+----------------+--> +--> name-list --+ show-modules = -+------------+-> MODULES -+----------------------------+-+---------------+-> +-> SYSTEM -+ +> ( ++> COMMENT ----++> ) --+ +-> name-list -+ +-> ALL -----+ |+> FUNCTIONS --+| |+> ID ---------+| |+> NAME -------+| ||> OWNER ------+| |+> PROCEDURES -+| |+> VARIABLES --+| +------ , <------+ show-outlines ---> OUTLINES -+---------------+--> +-> name-list --+ show-profiles = --> PROFILES -+---------------+--> +-> name-list --+ name-list = -+-+---------------++- * --------------+-+-> | +-> <alias> . --++-> <object-name> -+ | | | +----------------- , <------------------+ show-privileges = --+-> PROTECTION ON -++-> TABLES ----+-> <table-name> +----------+-> | || +------- , <-----+ | +-> PRIVILEGES ON -++-> VIEWS -----+-> <view-name> -+----------+ | +------- , <-----+ | +-> COLUMNS ---+-> <column-name> -+--------+ | +------- , <-------+ | +-> DATABASE --+-> <alias> +---------------+ | +---- , <---+ | +-> FUNCTION --+-> <function-name> ----+---+ | +----------- , <--------+ | +-> PROCEDURE -+-> <procedure-name> -----+-+ | +----------- , <----------+ | +-> MODULE ----+-> <module-name> +---------+ | +------- , <------+ | +-> SEQUENCE --+-> <sequence-name> -+------+ +------------ , <----+ show-procedures = -+-----------+--> PROCEDURES +--------------------------++---------------+-> +-> SYSTEM -+ +> ( ++> COMMENT ----++> ) ++-> name-list --+ +-> ALL ----+ |+> ID ---------+| |+> LANGUAGE ---+| |+> MODULE -----+| |+> OWNER ------+| |+> PARAMETER --+| |+> SOURCE -----+| +------ , <------+ show-roles = ---> ROLES -+--------------+-> +-> name-list -+ show-schemas = --> SCHEMAS -+---------------+-> +-> name-list --+ show-sequences= ---> SEQUENCES -+---------------+-> +-> name-list --+ show-storage-areas = --> STORAGE AREAS --+---------------------------------------+-> +-> name-list --------------------------+ +-> ( ++> USAGE -------++> ) name-list -+ |+> ATTRIBUTES --+| +----- , <--------+ show-storage-maps = -+-----------+-> STORAGE MAPS -+----------------+--------------------+-> +-> SYSTEM -+ +-> name-list ---+ | +-> ALL ----+ +-> ( PARTITIONS -> ) -> name-list --+ show-synonyms = ---> SYNONYMS -+---------------+--> +-> name-list --+ show-tables = -+-----------+-> TABLES -+-------------------------------------------+-> +-> SYSTEM -+ +-> name-list ------------------------------+ +-> ALL ----+ +-> ( -++-> COLUMNS -----++-> ) name-list --+ |+-> COMMENT -----+| |+-> CONSTRAINTS -+| |+-> INDEXES -----+| |+-> STORAGE MAPS +| |+-> TRIGGERS ----+| +-------- , <------+ show-triggers = -+-----------+-> TRIGGERS -+---------------+--> +-> SYSTEM -+ +-> name-list --+ +-> ALL ----+ show-users = ---> USERS --+---------------+--> +-> name-list --+ show-users-granting = --> USERS GRANTING ---+ +---------------------+ ++> db-privs-ansi ------> ON DATABASE -+-> <alias> +-----------------++ | +---- , <---+ || +> table-privs-ansi ----> ON TABLE -+-> <table-name> +--------------+| | +------- , <-----+ || +> column-privs-ansi ---> ON COLUMN -+-> <column-name> --+-----------+| | +------- , <--------+ || +> ext-routine-privs-ansi +-> ON FUNCTION +> <function-name -----+---+| | | +--------- , <---------+ || | +--> ON PROCEDURE +> <procedure-name -----++| | +--------- , <----------+|| +> module-privs-ansi ---> ON MODULE --+-> <module-name> --+----------+| | +----- , <----------+ || +> sequence-privs-ansi --> ON SEQUENCE -+> <sequence-name> -+--------+| +--- , <------------+ | +-------------------------------------------------------------------+ +---> TO -+-> identifier-ansi-style ---+---> +-> PUBLIC ------------------+ show-views = --+-----------+-> VIEWS -+------------------------------+-+ +-> SYSTEM -+ +-> ( -+-+-> COLUMNS -+-+-> ) -+ | +-> ALL ----+ | +-> COMMENT -+ | | | +-> SOURCE --+ | | +------ , <------+ | +--------------------------<-----------------------------+ +-+---------------+-------------> +-> name-list --+ db-privs-ansi = ----+---+-+-> SELECT -----+-+----+-> | | +-> INSERT -----+ | | | | +-> OPERATOR ---+ | | | | +-> DELETE -----+ | | | | +-> CREATE -----+ | | | | +-> ALTER ------+ | | | | +-> DROP -------+ | | | | +-> DBCTRL -----+ | | | | +-> DBADM ------+ | | | | +-> SHOW -------+ | | | | +-> REFERENCES -+ | | | | +-> UPDATE -----+ | | | | +-> SECURITY ---+ | | | | +-> DISTRIBTRAN + | | | +------- , <--------+ | +-------> ALL PRIVILEGES ----+ table-privs-ansi = -+--+-+-> SELECT -------------------------------+-+-+-> | | +-> INSERT -------------------------------+ | | | | +-> OPERATOR -----------------------------+ | | | | +-> DELETE -------------------------------+ | | | | +-> CREATE -------------------------------+ | | | | +-> ALTER --------------------------------+ | | | | +-> DROP ---------------------------------+ | | | | +-> DBCTRL -------------------------------+ | | | | +-> SHOW ---------------------------------+ | | | | +-> REFERENCES +--------------------------+ | | | | | +> ( +> <column-name> +> ) + | | | | | +----- , <-------+ | | | | | +-> UPDATE +---------------------- ------+ | | | | +> ( +> <column-name> -+---> ) + | | | | +----- , <--------+ | | | +------------------- , <----------------------+ | +------> ALL PRIVILEGES ---------------------------+ column-privs-ansi = ---+-+-+-> UPDATE -----+-+--+--> | | +-> REFERENCES -+ | | | +------- , <--------+ | +-----> ALL PRIVILEGES --+ ext-routine-privs-ansi = -+--+-+-> ALTER ------------------------------+-+--+--> | | +-> DBCTRL -----------------------------+ | | | | +-> DROP -------------------------------+ | | | | +-> EXECUTE ----------------------------+ | | | | +-> REFERENCES -------------------------+ | | | | +-> SHOW -------------------------------+ | | | +------------------- , <--------------------+ | +------> ALL PRIVILEGES --------------------------+ module-privs-ansi = -+--+-+-> ALTER ------------------------------+-+--+--> | | +-> DBCTRL -----------------------------+ | | | | +-> DROP -------------------------------+ | | | | +-> EXECUTE ----------------------------+ | | | | +-> REFERENCES -------------------------+ | | | | +-> SHOW -------------------------------+ | | | +------------------- , <--------------------+ | +------> ALL PRIVILEGES --------------------------+ identifier-ansi-style = ------> user-identifier --------> show-users-with = --> USERS WITH -------+ +---------------------+ ++> db-privs-ansi -------> ON DATABASE -+-> <alias> +-----------------++ | +---- , <---+ || +> table-privs-ansi -----> ON TABLE -+-> <table-name> +--------------+| | +------- , <-----+ || +> column-privs-ansi ----> ON COLUMN -+-> <column-name> -+------------+| | +------- , <-------+ || +> ext-routine-privs-ansi -+> ON FUNCTION -+> <function-name> ----+---+| | | +--------- , <---------+ || | +-> ON PROCEDURE -+> <procedure-name> ----++| | +--------- , <----------+|| +> module-privs-ansi ----> ON MODULE --+-> <module-name> +------------+| | +----- , <--------+ || +> sequence-privs-ansi --> ON SEQUENCE -+-> <sequence-name> -+--------+| +---- , <------------+ | +--------------------------------------------------------------------+ +--> FROM +-> identifier-ansi-style ---+---> +-> PUBLIC ------------------+ sequence-privs-ansi = -+-+-+-> ALTER -----+-+-+--> | | +-> DBCTRL ----+ | | | | +-> DROP ------+ | | | | +-> SELECT ----+ | | | +------- , <-------+ | +--> ALL PRIVILEGES ---+ show-session-information = -+-> ANSI DATE MODE -----------+-> +-> ANSI IDENTIFIERS MODE ----+ +-> ANSI QUOTING MODE --------+ +-> AUTOMATIC TRANSLATION ----+ +-> CONSTRAINT MODE ----------+ +-> CONTINUATION CHARACTER ---+ +-> CURRENCY SIGN ------------+ +-> DATE FORMAT --------------+ +-> DICTIONARY ---------------+ +-> DIGIT SEPARATOR ----------+ +-> DISPLAY ------------------+ +-> EXECUTION MODE -----------+ +-> FLAGGER MODE -------------+ +-> HOLD CURSORS MODE --------+ +-> LANGUAGE -----------------+ +-> RADIX POINT --------------+ +-> SQLCA --------------------+ +-> TRANSACTION --------------+ +-> VERSIONS -----------------+ +-> WARNING MODE -------------+