DESCRIBE SCHEMA - Kinetica Docs

Lists the contained tables and views of a given schema.

DESCRIBE SCHEMA Syntax

DESC[RIBE] [SCHEMA] <schema name>

Parameters

SCHEMA

Optional clause to avoid ambiguity; if omitted, and a table or view exists with the given name, the command will be interpreted as a DESCRIBE TABLE statement instead

Name of the schema whose contained tables & views will be listed

Examples

To describe the tables contained in the demo schema, into which demo data is usually downloaded:

DESCRIBE SCHEMA Example

DESC demo

DESCRIBE SCHEMA Output

+------------+
| Set_name   |
+------------+
| stocks     |
| nyctaxi    |
| flights    |
+------------+

SHOW SCHEMA SET CURRENT SCHEMA

⌘I

​Parameters

​Examples

Parameters

Examples