EXEMPLO_1212310
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_removetrigger
Parameters
Name
Type
Mode
@nometabela
nvarchar
IN
Definition
create procedure sp_removetrigger @nometabela sysname as declare @nometabelacomp varchar(30) set @nometabelacomp = @nometabela; if (len(@nometabelacomp) >= 20) set @nometabelacomp = '_' + substring (@nometabelacomp, len(@nometabelacomp)-19, 30) IF EXISTS (SELECT name FROM sysobjects WHERE name = 'logdelete'+@nometabelacomp AND type = 'TR') execute ('drop trigger logdelete'+@nometabelacomp ) IF EXISTS (SELECT name FROM sysobjects WHERE name = 'loginsert'+@nometabelacomp AND type = 'TR') execute ('drop trigger loginsert'+@nometabelacomp ) IF EXISTS (SELECT name FROM sysobjects WHERE name = 'logupdate'+@nometabelacomp AND type = 'TR') execute ('drop trigger logupdate'+@nometabelacomp )