你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

.drop external table command

  • 项目

Applies to: ✅ Microsoft Fabric ✅ Azure 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" }]		 {}