title: Track changes in constraint keys in sql server
body: <p>I am trying to create a trigger which logs a table tracking all DDL Changes including: </p>
  
  <ul>
  <li>CREATE</li>
  <li>ALTER </li>
  <li>DROP </li>
  </ul>
  
  <p>On Tables, views, functions, procedures and index using EventData() and Event Type. This table must log following info of the events </p>
  
  <ul>
  <li>database name</li>
  <li>schema name</li>
  <li>IP address </li>
  <li>user name</li>
  <li>event type</li>
  <li>modification date etc .</li>
  </ul>
  
  <p>I also want to track add constraint and drop constraint but there is no event type which supports this.</p>
  
  <p>How can I add this to my trigger?</p>