object-catalog-views-transact-sql.md

title	Object Catalog Views (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	object catalog views [SQL Server] catalog views [SQL Server], objects
ms.assetid	e8670a6b-e15c-4126-8d2d-c9cfb968a12d
caps.latest.revision	35
author	BYHAM
ms.author	rickbyh
manager	jhubbard

Object Catalog Views (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

This section contains the following catalog views.

sys.allocation_units	sys.objects
sys.assembly_modules	sys.parameters
sys.check_constraints	sys.partitions
sys.columns	sys.periods
sys.computed_columns	sys.procedures
sys.default_constraints	sys.sequences
sys.events	sys.service_queues
sys.event_notifications	sys.sql_dependencies
sys.extended_procedures	sys.sql_expression_dependencies
sys.foreign_key_columns	sys.sql_modules
sys.foreign_keys	sys.stats
sys.function_order_columns	sys.stats_columns
sys.hash_indexes	sys.synonyms
sys.identity_columns	sys.table_types
sys.index_columns	sys.tables
sys.indexes	enter link description here
sys.trigger_event_types	sys.key_constraints
sys.trigger_events	sys.masked_columns
sys.triggers	sys.memory_optimized_tables_internal_attributes
sys.views	sys.numbered_procedure_parameters
sys.numbered_procedures

See Also

System Catalog Views System Views (Transact-SQL)