.drop external table command

Drops an external table.

The external table definition can't be restored following this operation.

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

Permissions

You must have at least External Table Admin permissions to run this command.

.drop external table TableName [ifexists]

Name	Type	Required	Description
TableName	`string`	✔️	The name of the external table to drop.
`ifexists`	`string`		If specified, the command won't fail if the table doesn't exist.

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

.drop external table ExternalBlob

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