Re: dba script to generate trigger creation statements...does it exist?

From: <lalaina_at_my-dejanews.com>
Date: Thu, 20 Aug 1998 12:04:29 GMT
Message-ID: <6rh3cd$30p$1@nnrp1.dejanews.com>

connect sys/<Password>@....

select trigger_name , table_name, trigger_body from SYS.dba_triggers
where table_name = .....

That would work.

Cheers

Lalaina

In article <35db01f6.0_at_news.hawaii.rr.com>, "James" <sqljames_at_aol.com> wrote:
> Does anyone have or know of SQL that I can run off of DBA tables to get
> a trigger creation script.
>
> thank you in advance,
>
> -jef
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 20 1998 - 07:04:29 CDT