MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Get Trigger Name with Column Name
Posted by: Yasser Shahzad Qureshi
Date: February 21, 2011 03:57AM

You mean to say that I must first get a list of all the triggers available in the database then read through their definition to find if the column is being used in that trigger, if so then add that trigger's name in the drop script so when the script is executed, the trigger also gets deleted.

Well I think this whole pratice is not feasible as there may be 1000s of triggers in the system and for each column I would need to search the definition of these 1000s of triggers.So I am not comfirtable with that, as that is going to take a long time to complete the execution.

There should be some other way around, some way to identify the triggers which access a certain column.

Options: ReplyQuote

Written By
Re: Get Trigger Name with Column Name
February 21, 2011 03:57AM

Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.