Home
SQL Server / T-SQL Tutorial
Query
Insert Delete Update
Table
Table Join
Data Types
Set Operations
Constraints
Subquery
Aggregate Functions
Date Functions
Math Functions
String Functions
Data Convert Functions
Analytical Functions
Sequence Indentity
View
Index
Cursor
Database
Transact SQL
Procedure Function
Trigger
Transaction
XML
System Functions
System Settings
System Tables Views
User Role
CLR
sysobjects « System Tables Views « SQL Server / T-SQL Tutorial
SQL Server / T-SQL Tutorial
System Tables Views
sysobjects
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