sys.sp_cleanup_data_retention (Transact-SQL)
Applies to: Azure SQL Edge
Performs cleanup of obsolete records from tables that have data retention policies enabled. For more information, see Data Retention.
Syntax
sys.sp_cleanup_data_retention
{ [@schema_name = ] 'schema_name' },
{ [@table_name = ] 'table_name' },
[ [@rowcount =] rowcount OUTPUT ]
Arguments
[ @schema_name = ] schema_name
Is the name of the owning schema for the table on which cleanup needs to be performed. schema_name is a required parameter of type sysname.
[ @table_name = ] 'table_name'
Is the name of the table on which cleanup operation needs to be performed. table_name is a required parameter of type sysname.
Output parameter
[ @rowcount = ] rowcount OUTPUT
rowcount is an optional OUTPUT parameter that represents the number of records cleanup from the table. rowcount is int.
Permissions
Requires db_owner permissions.