Object Catalog Views (Transact-SQL)

This section contains the following catalog views.

sys.allocation_units

sys.numbered_procedures

sys.assembly_modules

sys.numbered_procedure_parameters

sys.check_constraints

sys.objects

sys.columns

sys.parameters

sys.computed_columns

sys.partitions

sys.default_constraints

sys.procedures

sys.events

sys.service_queues

sys.event_notifications

sys.sql_dependencies

sys.extended_procedures

sys.stats

sys.foreign_keys

sys.stats_columns

sys.foreign_key_columns

sys.sql_modules

sys.fulltext_indexes

sys.synonyms

sys.fulltext_index_columns

sys.tables

sys.identity_columns

sys.views

sys.indexes

sys.triggers

sys.index_columns

sys.trigger_events

sys.key_constraints

sys.traces (Transact-SQL)

See Also

Reference

Catalog Views (Transact-SQL)
System Views (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance