Data Dictionary Mapping

C.2 Data Dictionary Mapping

The tables in this section list Oracle data dictionary view names and the equivalent SQL Server system tables used.

A plus sign (+) indicates that a join operation is involved.

Table C-1 Oracle Data Dictionary View Names and SQL Server Equivalents

View Name	SQL Server System Table Name
`ALL_CATALOG`	`sysusers` + `sysobjects`
`ALL_COL_COMMENTS`	`sysusers` + `sysobjects` + `syscolumns`
`ALL_CONS_COLUMNS`	`sp_pkeys` + `sp_fkeys`
`ALL_CONSTRAINTS`	`sysusers` + `sysobjects` + `sysindexes` + `sysconstraints` + `sysreferences`
`ALL_IND_COLUMNS`	`sysusers` + `sysindexes` + `syscolumns`
`ALL_INDEXES`	`sysusers` + `sysindexes` + `sysobjects`
`ALL_OBJECTS`	`sysusers` + `sysobjects` + `sysindexes`
`ALL_TAB_COLUMNS`	`sysusers` + `sysobjects` + `syscolumns`
`ALL_TAB_COMMENTS`	`sysusers` + `sysobjects`
`ALL_TABLES`	`sysusers` + `sysobjects`
`ALL_USERS`	`sysusers`
`ALL_VIEWS`	`sysusers` + `sysobjects` + `syscomments`
`DBA_CATALOG`	`sysusers` + `sysobjects`
`DBA_COL_COMMENTS`	`sysusers` + `sysobjects` + `syscolumns`
`DBA_OBJECTS`	`sysusers` + `sysobjects` + `sysindexes`
`DBA_TABLES`	`sysusers` + `sysobjects`
`DBA_TAB_COLUMNS`	`sysusers` + `sysobjects` + `syscolumns`
`DBA_TAB_COMMENTS`	`sysusers` + `sysobjects`
`DICT_COLUMNS`	`sysobjects` + `syscolumns`
`DICTIONARY`	`sysobjects`
`DUAL`	`sysusers`
`TABLE_PRIVILEGES`	`sysprotects` + `sysusers` + `sysobjects`
`USER_CATALOG`	`sysusers` + `sysobjects`
`USER_COL_COMMENTS`	`sysusers` + `sysobjects` + `syscolumns`
`USER_CONS_COLUMNS`	`sp_pkeys` + `sp_fkeys`
`USER_CONSTRAINTS`	`sysusers` + `sysobjects` + `sysindexes` + `sysconstraints` + `sysreferences`
`USER_IND_COLUMNS`	`sysusers` + `sysindexes` + `syscolumns`
`USER_INDEXES`	`sysusers` + `sysindexes` + `sysobjects`
`USER_OBJECTS`	`sysusers` + `sysobjects` + `sysindexes`
`USER_TAB_COLUMNS`	`sysusers` + `sysobjects` + `syscolumns`
`USER_TAB_COMMENTS`	`sysusers` + `sysobjects`
`USER_TABLES`	`sysusers` + `sysobjects`
`USER_USERS`	`sysusers`
`USER_VIEWS`	`sysusers` + `sysobjects` + `syscomments`

Default Column Values
There is a minor difference between the gateway data dictionary and a typical Oracle database data dictionary.

Parent topic: Data Dictionary

C.2.1 Default Column Values

There is a minor difference between the gateway data dictionary and a typical Oracle database data dictionary.

The Oracle database columns that are missing in a SQL Server system table are filled with zeros, spaces, null values, not-applicable values (N.A.), or default values, depending on the column type.

Parent topic: Data Dictionary Mapping