USP_SCHEMA_TRIGGER_CLEARISSYSTEMFLAG
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TABLENAME | nvarchar(128) | IN | |
| @TRIGGERNAME | nvarchar(128) | IN | |
| @PARENTISVIEW | bit | IN |
Definition
Copy
CREATE procedure [dbo].[USP_SCHEMA_TRIGGER_CLEARISSYSTEMFLAG]
@TABLENAME nvarchar(128),
@TRIGGERNAME nvarchar(128),
@PARENTISVIEW bit = 0
with execute as caller
as
declare @parentObjectType nvarchar(max);
if @PARENTISVIEW = 1
set @parentObjectType = N'view';
else
set @parentObjectType = N'table';
if exists (select value from fn_listextendedproperty(N'BB_IsSystem', N'SCHEMA', N'dbo', @parentObjectType, @TABLENAME, N'trigger', @TRIGGERNAME))
exec sp_dropextendedproperty N'BB_IsSystem', N'SCHEMA', N'dbo', @parentObjectType, @TABLENAME, N'trigger', @TRIGGERNAME