Getting list of trigger names

Thread view:

Sankar - 11 Apr 2008 12:15 GMT

Hi,
pls help me how to get list of trigger names in a database through
JDBC.. I want to disable triggers for database migration ...

Regards
Sankar R

Reply to this Message

Thomas Kellerer - 11 Apr 2008 12:26 GMT

Sankar, 11.04.2008 13:15:

> Hi,
> pls help me how to get list of trigger names in a database through
> JDBC.. I want to disable triggers for database migration ...
>
> Regards
> Sankar R

There is no JDBC function for that. You will need to write a SQL statement specific for your DBMS

Thomas

Reply to this Message

Arne Vajhøj - 19 Apr 2008 17:59 GMT

> pls help me how to get list of trigger names in a database through
> JDBC.. I want to disable triggers for database migration ...

Many (but not all) databases will support:

SELECT * FROM INFORMATION_SCHEMA.TRIGGERS

Arne

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...