• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need to get table meta data

 
M Burke
Ranch Hand
Posts: 406
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I need to get a list of the triggers and constraints on tables. I looked at DatabaseMetaData & ResultSetMetaData but I don't see a method to get this information (Unless I am missing it). Any ideas?
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This might be because triggers and constraints aren't standard across all databases. You may have to write a query that goes against the db's system tables to do this or it could also possibly be part of a vendors jdbc implementation. What db are you using?
 
M Burke
Ranch Hand
Posts: 406
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using Oracle 10g. I think you are right. I need to query some kind of system table. Just not sure which ones.
 
Jan Cumps
Bartender
Posts: 2608
14
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic