Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
You must have at least Table Admin permissions to run this command.
.clear table TableName data
Learn more about syntax conventions.
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | The name of the table for which to clear the data. |
The following example clears all of the data in the table named LyricsAsTable.
.clear table LyricsAsTable data