.show external tables

Returns all external tables in the database (or a specific external table).

Requires Database monitor permission. This command is relevant to any external table of any type. For an overview of external tables, see external tables.

Syntax

.show external tables

.show external table TableName

Output

Output parameter Type Description
TableName string Name of external table
TableType string Type of external table
Folder string Table's folder
DocString string String documenting the table
Properties string Table's JSON serialized properties (specific to the type of table)

Example

.show external tables
.show external table T
TableName TableType Folder DocString Properties
T Blob ExternalTables Docs {}