| title | sp_syspolicy_delete_policy_category (Transact-SQL) | ||
|---|---|---|---|
| description | Deletes a policy category in Policy-Based Management. | ||
| author | VanMSFT | ||
| ms.author | vanto | ||
| ms.reviewer | randolphwest | ||
| ms.date | 06/23/2025 | ||
| ms.service | sql | ||
| ms.subservice | system-objects | ||
| ms.topic | reference | ||
| f1_keywords |
|
||
| helpviewer_keywords |
|
||
| dev_langs |
|
[!INCLUDE SQL Server]
Deletes a policy category in Policy-Based Management.
:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions
sp_syspolicy_delete_policy_category
{ [ @name = ] N'name' | [ @policy_category_id = ] policy_category_id }
[ ; ]
The name of the policy category. @name is sysname, and must be specified if @policy_category_id is NULL.
The identifier for the policy category. @policy_category_id is int, and must be specified if @name is NULL.
0 (success) or 1 (failure).
You must run sp_syspolicy_delete_policy_category in the context of the msdb system database.
You must specify a value for @name or for @policy_category_id. Both can't be NULL. To obtain these values, query the msdb.dbo.syspolicy_policy_categories system view.
To delete a policy category, the category can't be referenced by any policies.
Requires membership in the PolicyAdministratorRole fixed database role.
[!INCLUDE policy-administrator-role]
The following example deletes a policy category that is named Finance.
EXECUTE msdb.dbo.sp_syspolicy_delete_policy_category @name = N'Finance';
GO