Object Catalog Views (Transact-SQL)

sys.allocation_units

sys.parameters

sys.assembly_modules

sys.partitions

sys.check_constraints

sys.procedures

sys.columns

sys.sequences

sys.computed_columns

sys.service_queues

sys.default_constraints

sys.sql_dependencies

sys.events

sys.sql_expression_dependencies

sys.event_notifications

sys.sql_modules

sys.extended_procedures

sys.stats

sys.foreign_key_columns

sys.stats_columns

sys.foreign_keys

sys.synonyms

sys.function_order_columns

sys.table_types

sys.identity_columns

sys.tables

sys.index_columns

sys.trigger_event_types

sys.indexes

sys.trigger_events

sys.key_constraints

sys.triggers

sys.numbered_procedure_parameters

sys.views

sys.numbered_procedures

sys.objects