Object Catalog Views (Transact-SQL)

APPLIES TO: yes SQL Server Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse

This section contains links to 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.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