Modifier

Partager via


.clear table data command

Applies to: ✅ Microsoft FabricAzure 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