title: What happens to dependent triggers when the table is dropped?
body: <p>I have one table <code>backup</code> on which I had applied one trigger <code>upd_trig</code>. Now, I dropped my table and then I checked, whether all the associated trigger/index will also been dropped or will remain there. </p>
  
  <p>As I found some discussion <a href="http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/b4a2e31e-8de6-4251-93b3-585cda624c07/" rel="nofollow">here</a>,and they said Trigger/Index all will be dropped,once we drop our table. But, it seems, trigger still exist. Can anyone explain, what exactly happens, when we drop the table </p>
  
  <pre><code>SQL&gt; drop table backup;
  
  Table dropped.
  
  SQL&gt; select text from user_source;
  
  TEXT
  ----------------------------------------------------------------------------------------------------
  TRIGGER
  "BIN$Dg5j/bf6Rq6ugyN5ELwQkw==$0" BEFORE UPDATE ON backup FOR EACH ROW
  BEGIN
  INSERT INTO BACKUP VALUES(USER,:OLD.ENAME,SYSDATE);
  END;
  
  9 rows selected.
  
  SQL&gt; select count(*) from user_triggers;
  
    COUNT(*)
  ----------
           1
  
  SQL&gt; select trigger_name from user_triggers;
  
  TRIGGER_NAME
  ------------------------------
  BIN$Dg5j/bf6Rq6ugyN5ELwQkw==$0
  </code></pre>