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 Edit
Twitter LinkedIn Facebook Email

Object Catalog Views (Transact-SQL)

  • Article
  • 02/28/2023
  • 2 minutes to read

In this article

Applies to: SQL Server

This section contains links to the following catalog views.

sys.allocation_units

sys.assembly_modules

sys.check_constraints

sys.columns

sys.computed_columns

sys.default_constraints

sys.events

sys.event_notifications

sys.extended_procedures

sys.foreign_key_columns

sys.foreign_keys

sys.function_order_columns

sys.hash_indexes

sys.identity_columns

sys.index_columns

sys.trigger_event_types

sys.trigger_events

sys.triggers

sys.views

sys.numbered_procedures

sys.objects

sys.parameters

sys.partitions

sys.periods

sys.procedures

sys.sequences

sys.service_queues

sys.sql_dependencies

sys.sql_expression_dependencies

sys.sql_modules

sys.stats

sys.stats_columns

sys.synonyms

sys.table_types

sys.tables

sys.key_constraints

sys.masked_columns

sys.memory_optimized_tables_internal_attributes

sys.numbered_procedure_parameters

See Also

System Catalog Views System Views (Transact-SQL)


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