Need to get table meta data

[M Burke]

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]

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]

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]

select * from all_objects where object_type = 'TRIGGER'