code_junkie

What do the letter codes in Oracle user_contraints table's constraint_type column stand for?

Nov 11th, 2011
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. select distinct constraint_type from user_constraints;
  2.  
  3. C
  4. -
  5. C
  6. P
  7. R
  8. U
  9.  
  10. Type Code Type Description Acts On Level
  11. C Check on a table Column
  12. O Read Only on a view Object
  13. P Primary Key Object
  14. R Referential AKA Foreign Key Column
  15. U Unique Key Column
  16. V Check Option on a view Object
Add Comment
Please, Sign In to add comment