Which Data Dictionary holds information about Indexes and Constraints ?

  • Interview Candidate
  • 5
  • 6227

Showing Answers 1 - 5 of 5 Answers

sreenivasreddy

  • Jan 3rd, 2006
 

user_objects

  Was this answer useful?  Yes

Nagarjuna Reddy

  • Jan 9th, 2006
 

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

  Was this answer useful?  Yes

rajnarayan yadav

  • Jan 16th, 2006
 

 Index information in : user_indexes

 Constraint information in : user_constraints and user_cons_columns

  Was this answer useful?  Yes

Culver_lake

  • Mar 18th, 2006
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions