Skip to content

Latest commit

 

History

History
37 lines (25 loc) · 990 Bytes

clear-table-data-command.md

File metadata and controls

37 lines (25 loc) · 990 Bytes
Raw
title description ms.reviewer ms.topic ms.date
.clear table data command
Learn how to use the `.clear table data` command to clear data from an existing table.
vrozov
reference
05/24/2023

.clear table data command

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

[!INCLUDE syntax-conventions-note]

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