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.
Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Azure 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 |