Find the Triggers in the SQL server

Hello,

I have created a trigger in my database and is running. I can only find it using Select *
from sys.triggers. Why it does not appear under Programmability/Database Triggers?
Also, how can I edit the systax of the trigger?
MissNicolaAsked:
Who is Participating?
 
winston33Commented:
It is likely that you have a trigger on the table itself, so you can find each trigger by browsing to the table, expanding the table and then expanding the Triggers folder. If you right-click/Modify the trigger, you can update the syntax.
0
 
MissNicolaAuthor Commented:
Thanks, I found it. How can I add a trigger to be shown under programmability?
0
 
winston33Commented:
This is an area only for database-level triggers (e.g. DROP TABLE, ALTER TABLE, etc.). If you want to run a trigger for those types of events, right-click/New Database Trigger on the Programmability folder.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.