.show table policy auto_delete command

Applies to: ✅ Microsoft FabricAzure Data Explorer

Shows the auto delete policy that's applied to a table. For more information, see auto delete policy.

Permissions

You must have at least Database User, Database Viewer, or Database Monitor permissions to run this command. For more information, see role-based access control.

Syntax

.show table TableName policy auto_delete

Learn more about syntax conventions.

Parameters

Name Type Required Description
TableName string ✔️ The name of the table.

Returns

Name Type Description
PolicyName string Name of the policy. For table auto delete policy this value is AutoDeletePolicy.
EntityName string Name of the entity for which the policy is set. For table auto delete policy this value is [databaseName].[tableName], where databaseName corresponds to the name of the database in which in the table exists, and tableName to the name of the table itself.
Policy string JSON representation of the policy object.
ChildEntities string Child entities for which this policy is set. For table auto delete policy this value is an empty string.
EntityType string Type of entity for which this policy is set. For table auto delete policy this value is Table.

Examples

Show auto delete policy of a table

Show the auto delete policy that is applied to table T:

.show table T policy auto_delete

Output

PolicyName EntityName Policy ChildEntities EntityType
AutoDeletePolicy [database].[T] { "ExpiryDate": "2023-06-01T00:00:00" "DeleteIfNotEmpty": true } Table