Feedback Edit

.drop external table

  • Article
  • 2 minutes to read

Drops an external table.

The external table definition can't be restored following this operation. Requires database admin permission.

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

Syntax

.drop external table TableName [ifexists]

Output

Returns the properties of the dropped external table. For more information, see .show external tables.

Examples

.drop external table ExternalBlob
TableName TableType Folder DocString Schema Properties
T Blob ExternalTables Docs [{ "Name": "x", "CslType": "long"},
{ "Name": "s", "CslType": "string" }]		 {}