USP_PAGE_MODEL_DESIGN_ITEM_DELETE_DEPENDANTS
Executes the "Page Model Design Delete Dependents" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Input parameter indicating the ID of the record being deleted. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the delete. |
Definition
Copy
CREATE procedure dbo.USP_PAGE_MODEL_DESIGN_ITEM_DELETE_DEPENDANTS
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as begin
--check deletion rules, if any
--delete everything thats not a page, site, or theme
delete from PAGEMODELDESIGNITEM
where MODELID = @ID
and OBJECTTYPEID not in (2, 8, 39)
return 0;
end