| Server Configuration Options |
sys.configurations |
|
SELECT * FROM sys.configurations |
| List Databases |
sys.databases |
|
SELECT * FROM sys.databases |
| List Tables |
sys.tables |
|
SELECT * FROM sys.tables |
| List Columns from all Database Tables |
sys.columns |
|
SELECT * FROM sys.columns |
| List Registered Database Events |
sys.events |
|
SELECT * FROM sys.events |
| List views |
sys.views |
|
SELECT * FROM sys.views |
| Dynamic Management Views |
sys.dm_exec_* |
provide information about execution of .NET CLR Modules and connections. All contained here are a number of views available to help you drill into issues related to execution of queries |
|
| Dynamic Management Views |
sys.dm_os_* |
report on memory, locks, and execution scheduling |
|
| Dynamic Management Views |
sys.dm_trans_* |
provide insight into transactions and isolation |
|
| Dynamic Management Views |
sys.dm_io_* |
monitoring disk I/O |
|
| Dynamic Management Views |
sys.dm_db_* |
provide database-level data |
|
|
sys.indexes |
|
|
|
sys.objects |
|
SELECT * FROM sys.objects |
|
sys.allocation_units |
|
|
|
sys.numbered_procedures |
|
|
|
sys.assembly_modules |
|
|
|
sys.numbered_procedure_parameters |
|
|
|
sys.check_constraints |
|
|
|
sys.objects |
|
|
|
sys.parameters |
|
|
|
sys.computed_columns |
|
|
|
sys.partitions |
|
|
|
sys.default_constraints |
|
|
|
sys.procedures |
|
|
|
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.triggers |
|
|
|
sys.index_columns |
|
|
|
sys.trigger_events |
|
|
|
sys.key_constraints |
|
|
|
sys.traces (Transact-SQL) |
|
|
|
sys.backup_devices |
|
|
|
sys.database_files |
|
|
|
sys.database_mirroring |
|
|
|
sys.database_recovery_status |
|
|
|
sys.master_files |
|
|