| title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sp_syspolicy_delete_policy_category (Transact-SQL) |
Deletes a policy category in Policy-Based Management. |
VanMSFT |
vanto |
randolphwest |
08/21/2024 |
sql |
system-objects |
reference |
|
|
|
[!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.
EXEC msdb.dbo.sp_syspolicy_delete_policy_category @name = N'Finance';
GO