Feedback Edit

.show external table schema

  • Article
  • 2 minutes to read

Returns the schema of the external table, as JSON or CSL.

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 table TableName schema as (json | csl)

.show external table TableName cslschema

Output

Output parameter Type Description
TableName string Name of external table
Schema string The table schema in a JSON format
DatabaseName string Table's database name
Folder string Table's folder
DocString string String documenting the table

Examples

.show external table T schema as json

.show external table T schema as csl
.show external table T cslschema

Example output

json:

TableName Schema DatabaseName Folder DocString
T {"Name":"ExternalBlob",
"Folder":"ExternalTables",
"DocString":"Docs",
"OrderedColumns":[{"Name":"x","Type":"System.Int64","CslType":"long","DocString":""},{"Name":"s","Type":"System.String","CslType":"string","DocString":""}]}		 DB ExternalTables Docs

csl:

TableName Schema DatabaseName Folder DocString
T x:long,s:string DB ExternalTables Docs