Object Catalog Views (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.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)