.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.
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" }] |
{} |
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om