remidian.com

play Mount of Olives

remidian is remi visser, oracle dba contractor from the Netherlands you can browse my work related braindumps, read my resume or contact me

home mssql

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

No Comments, Comment or Ping

Reply to “MSSQL cheat sheet for the Oracle minded”