MSSQL cheat sheet for the Oracle minded

A translation of oracle dba_* tables/v$* views/functions to their respective mssql counterparts.

dba_* tables

Oracle Table/View MSSQL Table/View Note
dba_data_files (and v_$logfile) <database>.dbo.sysfiles Contains datafiles AND logfiles
dba_objects <database>.dbo.sysobjects  
dba_users master.dbo.sysxlogins (T)
master.dbo.syslogins (V)
  <database>.dbo.sysusers Containts users that belong to <database>. Subset of users in master.dbo.sysxlogins

Leave a Reply

Your email address will not be published. Required fields are marked *