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
Deletes the auto delete policy of a table. For more information, see auto delete policy.
Permissions
You must have at least Table Admin permissions to run this command.
Syntax
.delete table TableName policy auto_delete
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| TableName | string |
✔️ | 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. When the policy is deleted with this command, this property is set to null. |
| 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 an empty string. |
Examples
Remove auto delete policy of a table
Remove auto delete policy of table T:
.delete table T policy auto_delete
Output
| PolicyName | EntityName | Policy | ChildEntities | EntityType |
|---|---|---|---|---|
| AutoDeletePolicy | [database].[T] | null |