Skip to main content Skip to Ask Learn chat experience

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

Note

Access to this page requires authorization. You can try signing in or changing directories.

Access to this page requires authorization. You can try changing directories.

In this article

Object Catalog Views (Transact-SQL)

This section contains the following catalog views.

sys.allocation_units

sys.parameters

sys.assembly_modules

sys.partitions

sys.check_constraints

sys.procedures

sys.columns

sys.service_queues

sys.computed_columns

sys.spatial_index_tessellations

sys.default_constraints

sys.spatial_indexes

sys.events

sys.sql_dependencies

sys.event_notifications

sys.sql_expression_dependencies

sys.extended_procedures

sys.sql_modules

sys.foreign_key_columns

sys.stats

sys.foreign_keys

sys.stats_columns

sys.function_order_columns

sys.synonyms

sys.identity_columns

sys.table_types

sys.index_columns

sys.tables

sys.indexes

sys.trigger_event_types

sys.key_constraints

sys.trigger_events

sys.numbered_procedure_parameters

sys.triggers

sys.numbered_procedures

sys.views

sys.objects

See Also

Reference

Catalog Views (Transact-SQL)

System Views (Transact-SQL)


Additional resources


  • Last updated on 2012-10-04

In this article

en-us
Your Privacy Choices
  • AI Disclaimer
  • Previous Versions
  • Blog
  • Contribute
  • Privacy
  • Consumer Health Privacy
  • Terms of Use
  • Trademarks
  • © Microsoft 2026