Re: How to I see triggers in 5.x?

In article <359A85D2.E00D47F9@agcs.com>, Roger Tomas <tomasr@agcs.com> wrote: > > Darrel, Davis wrote: > > > How can I see triggers that are installed? I am working on an > > older system and I believe there are triggers dinkin with my input > > data. How do I determine if a table has a trigger? > > > > Any help appreciated. > > > > -darrel > > > > ====================================================== > > Darrel Davis darrel.davis@geis.ge.com > > darreld@his.com > > ====================================================== > > Use dbschema to display the schema for the suspect table. > The schema information will include any triggers that exist. > > Roger Tomas > AG Communication Systems > > Quite right, but I suspect that Darrel is looking for a way to identify all tables that have triggers associated with them BEFORE running dbschema to get the trigger detail. The following will achieve this on 5.xx :- select trigname, tabname from systriggers a, systables b where a.tabid = b.tabid Be aware, of course, that triggers only came to be at 5.01, therefore if your engine precedes version 5.01, Darrel, triggers will not be the cause of your problem. Regards Glyn Balmer -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum