你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。
.clear table data command
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
Clears the data of an existing table, including streaming ingestion data.
Note
In the event of a partial success or failure, an exception is thrown with detailed information about the error.
Permissions
You must have at least Table Admin permissions to run this command.
Syntax
.clear table TableName data
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | The name of the table for which to clear the data. |
Example
The following example clears all of the data in the table named LyricsAsTable.
.clear table LyricsAsTable data