| View Name | View Description |
|---|
| Sys.Sysobjects | contains all the objects created in sqlserver |
| Sys.sysservers | contains info about the servers |
| Sys.sysremotelogins | contains info about remotelogins |
| Sys.sysprocesses | current processes being done by sqlserver |
| Sys.sysperfinfo | Info about all types of performance related counters performing on Server |
| Sys.sysmessages | Info about all error messages with error id and severtiy |
| Sys.syslogins | complete detailed info regarding creating the login including password,default Db,lang etc |
| Sys.sysdatabases | info about DB name,DBID,version,CrDate,MDF location etc |
| Sys.syscursortables | info about cursors created in DB |
| Sys.sysconfigures | info about server configuration |
| Sys.syslanguages | info about all the languages that server supports |
| Sys.syscacheobjects | info about sysobjects getting updated when somethg happened wrt to DB or server |
| Sys.sysaltfiles | info of All DB's Data and Log files and its properties |
| Sys.sysfiles | info about system files with physical location |
| Sys.sysusers | info about the users of Server |
| Sys.systypes | Datatypes of SQLServer with all its properties |
| Sys.sysconstraints | Constraints described in DB |
| Sys.sysforeignkeys | Foreign keys described in DB |
| Sys.syscomments | contains info of all system inbuilt views/procs/functions |
| Sys.all_sql_modules | contains definition of all system inbuilt views/procs/functions |
| Sys.syscolumns | Columns defined in the DB's |
| Sys.sysobjects | All objects details |
| Sys.all_parameters | Parameters declared along the DB's |
| Sys.all_columns | Columns defined in the DB's |
| Sys.all_views | All views of DB's |
| Sys.all_objects | All objects of DB's |
| Sys.sys.dm_tran_active_transactions | to find active transactions |
| Sys.sp_delete_backuphistory | will delete the complete backup history |
| Sys.msdb..restorehistory | table which has all the details of databases restored |
