Is there a way to list which tables have active triggers? I know about LIST.SICA tablename, but if I make a change to the trigger program, and I need to DROP the trigger from all the TABLES usings it, how would I find out all the TABLES that are using that trigger?
Is there an easier way to DROP/CREATE when modifying a trigger, if say the trigger is being used on 40 or 50 TABLES? For now I'll create a PAragraph that does the CREATEing and one that does the DROPing, and just add to each time a new TABLE is added to that trigger, then it would just be a matter of running the one PAragraph to drop, recompile, then other PAragraph to CREATE. George George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator [email protected] ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
