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

Helpful? - leave your note below so I can brag

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>