PROBLEM - Oracle - SQL to get all constraints for a Table

Problem


Get all constraints for a Table


Solution 


Use the following SQL

select * from user_constraints where table_name = '<TABLE_NAME>'



Subscribe to Java News and Posts. Get latest updates and posts on Java from Buggybread.com
Enter your email address:
Delivered by FeedBurner
comments powered by Disqus