Stored Procedures [dbo].[DeleteModelPerspectives]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@ModelIDuniqueidentifier16
Permissions
TypeActionOwning Principal
GrantExecuteRSExecRole
SQL Script
CREATE PROCEDURE [dbo].[DeleteModelPerspectives]
@ModelID as uniqueidentifier
AS
DELETE
FROM [ModelPerspective]
WHERE [ModelID] = @ModelID

GO
GRANT EXECUTE ON  [dbo].[DeleteModelPerspectives] TO [RSExecRole]
GO
Uses