sysobjects « System Tables Views « SQL Server / T-SQL Tutorial

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