ObjectType Trace Event Column
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
The Object Type trace event column is used in a variety of trace events. This topic describes the possible values of this column and their associated definitions.
Object Type Column Values
| Value | Definition |
|---|---|
| 8259 | Check Constraint |
| 8260 | Default (constraint or standalone) |
| 8262 | Foreign-key Constraint |
| 8272 | Stored Procedure |
| 8274 | Rule |
| 8275 | System Table |
| 8276 | Trigger on Server |
| 8277 | (User-defined) Table |
| 8278 | View |
| 8280 | Extended Stored Procedure |
| 16724 | CLR Trigger |
| 16964 | Database |
| 16975 | Object |
| 17222 | FullText Catalog |
| 17232 | CLR Stored Procedure |
| 17235 | Schema |
| 17475 | Credential |
| 17491 | DDL Event |
| 17741 | Management Event |
| 17747 | Security Event |
| 17749 | User Event |
| 17985 | CLR Aggregate Function |
| 17993 | Inline Table-valued SQL Function |
| 18000 | Partition Function |
| 18002 | Replication Filter Procedure |
| 18004 | Table-valued SQL Function |
| 18259 | Server Role |
| 18263 | Microsoft Windows Group |
| 19265 | Asymmetric Key |
| 19277 | Master Key |
| 19280 | Primary Key |
| 19283 | ObfusKey |
| 19521 | Asymmetric Key Login |
| 19523 | Certificate Login |
| 19538 | Role |
| 19539 | SQL Login |
| 19543 | Windows Login |
| 20034 | Remote Service Binding |
| 20036 | Event Notification on Database |
| 20037 | Event Notification |
| 20038 | Scalar SQL Function |
| 20047 | Event Notification on Object |
| 20051 | Synonym |
| 20307 | Sequence |
| 20549 | End Point |
| 20801 | Adhoc Queries which may be cached |
| 20816 | Prepared Queries which may be cached |
| 20819 | Service Broker Service Queue |
| 20821 | Unique Constraint |
| 21057 | Application Role |
| 21059 | Certificate |
| 21075 | Server |
| 21076 | Transact-SQL Trigger |
| 21313 | Assembly |
| 21318 | CLR Scalar Function |
| 21321 | Inline scalar SQL Function |
| 21328 | Partition Scheme |
| 21333 | User |
| 21571 | Service Broker Service Contract |
| 21572 | Trigger on Database |
| 21574 | CLR Table-valued Function |
| 21577 | Internal Table (For example, XML Node Table, Queue Table.) |
| 21581 | Service Broker Message Type |
| 21586 | Service Broker Route |
| 21587 | Statistics |
| 21825 21827 21831 21843 21847 |
User |
| 22099 | Service Broker Service |
| 22601 | Index |
| 22604 | Certificate Login |
| 22611 | XMLSchema |
| 22868 | Type |