.clear table data command
Applies to: ✅ 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