title: Renaming a table while leaving the existing triggers behind
body: <p>A decision was made to join a couple of existing tables together in a cluster.</p>
  
  <p>This obviously means that the tables need to be recreated so they can be clustered together, however the existing data should be preserved.</p>
  
  <p>Naturally I assume the procedure would be something along the lines of:</p>
  
  <ul>
  <li>Back up existing table under a different name (via a rename or something)</li>
  <li>Create a new clustered table under the old name</li>
  <li>Copy all the data from the backup table into the newly created one</li>
  </ul>
  
  <p>However the current table has quite a few triggers assigned to it (and correct me if I'm wrong here but) when I'll execute the rename operation on that table I assume all the triggers assigned to it by order of convenience will refactor themselves to match the new name.</p>
  
  <p>The perfect scenario in this case would probably be for the triggers to temporarily "detach" themselves from the table once it gets renamed (still point to the old table name which would not exist at that point), and then would be once again functional when the newly created clustered table appears.</p>
  
  <p>However I'm not sure if this is possible.</p>
  
  <p><strong>So the question here is:</strong> Can I leave the triggers behind when renaming the table, or should I deal with them manually?</p>