Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge
Read in English
Read in English
Twitter LinkedIn Facebook Email

Object Catalog Views (Transact-SQL)

  • Article
  • 12/03/2008

In this article

This section contains the following catalog views.

sys.allocation_units

sys.numbered_procedures

sys.assembly_modules

sys.numbered_procedure_parameters

sys.check_constraints

sys.objects

sys.columns

sys.parameters

sys.computed_columns

sys.partitions

sys.default_constraints

sys.procedures

sys.events

sys.service_queues

sys.event_notifications

sys.sql_dependencies

sys.extended_procedures

sys.stats

sys.foreign_keys

sys.stats_columns

sys.foreign_key_columns

sys.sql_modules

sys.fulltext_indexes

sys.synonyms

sys.fulltext_index_columns

sys.tables

sys.identity_columns

sys.views

sys.indexes

sys.triggers

sys.index_columns

sys.trigger_events

sys.key_constraints

sys.traces (Transact-SQL)

See Also

Reference

Catalog Views (Transact-SQL)
System Views (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance


Additional resources

  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2023

Additional resources

In this article

  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2023