Join objects and schemas : sys.schemas « System Tables Views « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Tables Views
3. sys.schemas

5> IF EXISTS(SELECT *
6>     FROM sys.objects o JOIN sys.schemas s
7>     ON o.schema_id = s.schema_id
8>     WHERE type = 'TR' AND
9>     s.name = 'dbo' AND
10>     o.name = 'trStudentsEcho')
11>     DROP TRIGGER trStudentsEcho
12> GO