MySQL Forums
Forum List  »  Microsoft SQL Server

Get Trigger Name with Column Name
Posted by: Yasser Shahzad Qureshi
Date: February 14, 2011 08:22AM

I need to get the name's of the trigger's in which a particular column is being used, either inserted, or updated.

Actually I need to drop certain columns form different tables. So what I have done is that I have created a script which generate the drop script. But what happens is that after dropping the column, when the trigger in triggered and the column that has already been droped, is used in that trigger, I get an error [Column Name] not found.

So I also need to delete those triggers automatically in which a the column I need to delete is being used.

Options: ReplyQuote

Written By
Get Trigger Name with Column Name
February 14, 2011 08:22AM

Sorry, you can't reply to this topic. It has been closed.

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.