sys.trace_columns (Transact SQL)
The sys.trace_columns catalog view contains a list of all trace event columns. These columns do not change for a given version of the Microsoft SQL Server 2005 Database Engine.
For a complete list of supported trace events, see SQL Server Event Class Reference.
| Column name | Data type | Description |
|---|---|---|
trace_column_id |
smallint |
Unique ID of this column. |
name |
nvarchar(128) |
Unique name of this column. This parameter is not localized. |
type_name |
nvarchar(128) |
Data type name of this column. |
max_size |
int |
Maximum data size of this column in bytes. |
is_filterable |
bit |
Indicates whether the column can be used in filter specification. 0 = false 1 = true |
is_repeatable |
bit |
Indicates whether the column can be referenced in the "repeated column" data. 0 = false 1 = true |
is_repeated_base |
bit |
Indicates whether this column is used as a unique key for referencing repeated data. 0 = false 1 = true |
See Also
Reference
Object Catalog Views (Transact-SQL)
sys.traces (Transact-SQL)
sys.trace_categories (Transact SQL)
sys.trace_events (Transact SQL)
sys.trace_event_bindings (Transact SQL)
sys.trace_subclass_values (Transact SQL)