你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站,请访问 https://docs.azure.cn

.delete table policy update command

Applies to: ✅ Microsoft FabricAzure Data Explorer

Delete the table update policy. The update policy simplifies the process of syncing and updating data between two tables. When new data is inserted into the source table, a transformation query runs over this data to modify and insert the data into the target table.

Note

The source table and the table for which the update policy is defined must be in the same database. The update policy function schema and the target table schema must match in their column names, types, and order.

Permissions

You must have at least Table Admin permissions to run this command.

Syntax

.delete table [ DatabaseName.]TableName policy update

Learn more about syntax conventions.

Parameters

Name Type Required Description
DatabaseName string The name of the database. This is required when running the command from outside the database context of the specified table.
TableName string ✔️ The name of the table.

Returns

Returns a JSON representation of the policy.

Example

Delete the update policy for a table:

.delete table MyDatabase.MyTable policy update