|
|
Re: how do i see the trigger description [message #19132 is a reply to message #19129] |
Fri, 01 March 2002 07:56 |
ksr
Messages: 112 Registered: January 2002
|
Senior Member |
|
|
Hi,
I want to see the complete description as it was created.
The table does not give the full script to see the total description (total created text of trigger)
How to see the total description of the trigger as it was created
|
|
|
Re: how do i see the trigger description [message #19136 is a reply to message #19129] |
Fri, 01 March 2002 09:30 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
There is no place where the complete trigger text as originally entered is stored, but everything you need to re-create it is right there in the user_triggers view.
You've got the name, type, event, table, etc. Just concatenate the applicable columns together to form the original statement.
|
|
|