This discussion is archived
3 Replies Latest reply: Jul 19, 2013 3:36 AM by kiran_oracle RSS

how can i get  the column name   for assigned constraint name  from  the  user_constraints   table?????

kiran_oracle Newbie
Currently Being Moderated

Hi  ,

I  have a table  so  many constraints   on so  many  columns. I  need to  know  which column has which  constraint plsql dev?? like below...


table_name -------- col_name ------ constraint_name_of_that_col


    xxxxxx              xxxxxxx              xxxxxxxxxxxxxxxx



or else please let me know  how can i  get the  corresponding col_name for a particular  constraint name???


  • Correct Answers - 10 points
  • Helpful Answers - 5 points