Database - Which Data Dictionary holds information about Indexes and Constraints ?

GeekInterview.com > Interview Questions > Database

Go To First | Previous Question | Next Question

Database | Question 6 of 70

Which Data Dictionary holds information about Indexes and Constraints ?

Total Answers and Comments: 5

Last Update: March 19, 2006 Asked by: vcppvenkat

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 03, 2006 02:07:38

sreenivasreddy

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

user_objects

Is this answer useful? Yes | No

January 09, 2006 02:03:25

Nagarjuna Reddy

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

I think USER_OBJECTS wont give you about indexes .I think its either USER_CONSTRAINTS or ALL_CONSTRAINTS.

Is this answer useful? Yes | No

January 10, 2006 05:51:38

pankaj_gauba

Member Since: November 2005 Contribution: 16

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

User_Index and user_Constraints

Is this answer useful? Yes | No

January 16, 2006 10:46:02

rajnarayan yadav

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

Index information in : user_indexes

Constraint information in : user_constraints and user_cons_columns

Is this answer useful? Yes | No

March 18, 2006 21:23:45

Culver_lake

Member Since: March 2006 Contribution: 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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank