sys.trace_columns (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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 SQL Server Database Engine.

For a complete list of supported trace events, see SQL Server Event Class Reference.


This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Extended Event catalog views instead.

|Applies to: SQL Server ( SQL Server 2008 through current version).|

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


The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.

See Also

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)