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 …

Read more →