.show table policy auto_delete command

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