Dropping all the triggers in the database using a cursor and dynamic execution. : sysobjects « System Tables Views « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Tables Views
  3. sysobjects
4>
5>
6>     DECLARE cuTriggers CURSOR
7>         FOR
8>         SELECT name FROM sysobjects WHERE type = 'TR'
9>     OPEN cuTriggers
10>     DECLARE @chvTrigger VARCHAR(30)
11>     FETCH NEXT FROM cuTriggers INTO @chvTrigger
12>
13>     WHILE (@@fetch_status <> -1)
14>     BEGIN
15>         EXEC ("DROP TRIGGER "  + @chvTrigger)
16>
17>         FETCH NEXT FROM cutriggers INTO @chvTrigger
18>
19>     END
20>     DEALLOCATE cuTriggers
21>     GO
1>








27.33.sysobjects
27.33.1.sysobjects contains a row for each database object.
27.33.2.Dropping all the triggers in the database using a cursor and dynamic execution.
27.33.3.Retrieving all of the triggers for each table.
27.33.4.Query sysobjects for user table, not system table
27.33.5.Check the existance of a table by querying sysobjects