title: How to find all trigger associated with a table with SQL Server?
body: <p>I created a trigger for a table in <em>SQL Server</em> and it works for me.</p>
  
  <p>My problem is: How do find it and modify it?</p>
  
  <p>I use this query to find my triggers:</p>
  
  <pre><code>select * from sys.triggers
  </code></pre>
  
  <p>This find all triggers, but how to open it and change the triggers?</p>