Hi, If I use the DatabaseMetaData interface is there a method or an easy way to get triggers and stored procedures? Right now I have to create a vendor-specific SQL statement. Thanks for your help. -Yoo-Jin.
after a quick look i couldn't see anything about triggers, but i'd be interested to know if you find it. otherwise if you're using oracle or sql server & perhaps other dbs that i don't know, you can query the db dictionary like a normal table - you just have to know the codes & the column names
I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.
Joined: Nov 01, 2000
Hi, Looks like there isn't a method to find triggers I even asked the company where we purchased our jdbc drivers. Perhaps this could be something that could be added to the DatabaseMetaData interface - it's fairly easy enough to do. cheerios, Yoo-Jin