Sep 14, 2006
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”