title: How can I get the 'External name' of a SQL CLR trigger?
body: <p>I have created a SQL CLR trigger with the follow SQL:</p>
  
  <pre><code>GO
  CREATE TRIGGER AuditAccountsTable
     ON [dbo].[Accounts]
     FOR INSERT,DELETE,UPDATE
  AS 
  EXTERNAL NAME namespace.Triggers.AuditTrigger
  </code></pre>
  
  <p>I am trying to query:</p>
  
  <pre><code>select * from sys.triggers
  </code></pre>
  
  <p>Is there a way to find the: <code>EXTERNAL NAME namespace.Triggers.AuditTrigger</code> on the trigger from querying in the DB?</p>