show

Show Snapshots

Show Snapshots Summary The SHOW SNAPSHOTS command returns a result set listing all snapshot savepoints that exist in the Connect environment you have logged into.  Savepoints record the state of [&he...

Show Limits

Show Limits Summary The SHOW LIMITS command returns a result set summarizing the system usage limits imposed by Connect. Syntax show limits; Parameters None Details The SHOW LIMITS result set incl...

SHOW TABLES

SHOW TABLES Summary The SHOW TABLES command returns a result set containing metadata for all tables found in the Connect environment. Syntax show tables; Parameters None. Details The SHOW TABLES res...

SHOW TABLE

SHOW TABLE Summary The SHOW TABLE command returns a result set containing metadata describing the specified table. The metadata includes the table’s schema, columns, and column data types, amon...

SHOW

SHOW Summary The SHOW command returns a table result set that lists metadata for a specific kind of object. Syntax SHOW <object_type>; Parameters Parameter Description <object_type> The ty...

Show Variables

Show Variables Summary The SHOW VARIABLES command returns a result set listing all variables defined in the environment. Syntax show variables; Parameters None. Details The result set includes metadat...

Show Steps

Show Steps Summary The SHOW STEPS command returns a result set listing metadata for all step objects defined in the Connect environment. Syntax show steps;  Parameters None. Details Use the SELECT...

Show Step

Show Step Summary The SHOW STEP command returns a result set containing metadata for the specified step.   Syntax show step <step_name> [labels]; Parameters Parameter Description <step...

Show Schemas

Show Schemas Summary The SHOW SCHEMAS command returns a result set showing the schemas available in the Connect environment. Syntax show schemas; Parameters None. Details The Connect environment incl...

Show Schedules

Show Schedules Summary The SHOW SCHEDULES command returns a result set listing metadata for any schedule objects defined in the Connect environment. Syntax show schedules; Parameters None Details The...