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.
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 |