Answer Detail: RE: Which Data Dictionary holds information about Ind...

GeekInterview.com > Interview Questions > Database

Print |

Question: Which Data Dictionary holds information about Indexes and Constraints ?

March 03, 2006 21:23:45	#5
Culver_lake	Member Since: March 2006 Total Comments: 46
RE: Which Data Dictionary holds information about Ind...
These answers are probably all correct---if it's SQLServer or Sybase. I don't think the DBMS was identified and for sure the data dictionary/relational catalog/system tables are not standard in naming or contents. For instance in DB2 it's SYSIBM.SYSINDEXES and SYSIBM.SYSFOREIGNKEYS that holds what is being asked.