Home → mssql → MSSQL cheat sheet for the Oracle minded

MSSQL cheat sheet for the Oracle minded

Published on Thursday, September 14, 2006

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

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)
dba_users		<database>.dbo.sysusers	Containts users that belong to <database>. Subset of users in master.dbo.sysxlogins

remidian