.drop external table command

Applies to: ✅ Microsoft FabricAzure Data Explorer

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.

Syntax

.drop external table TableName [ifexists]

Learn more about syntax conventions.

Parameters

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

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" }]
{}