title: how to update table with foreign key
body: <p>Actually I have two databases, one is for staging one is in production.
  one table, for example called <code>Class(class_id,descr,faculty_id)</code> and the <code>faculty_id</code> reference to another table called <code>Faculty(faculty_id, name,comment)</code>.</p>
  
  <p>my story is that i do so much updates on the staging database, Faculty table, change lots of faculty comment and name without changing Class table. I want to copy the staging Faculty table to Production. My original way is to generate script from staging and delete the data table, Faculty in production and run the script in order to copy the staging data table Faculty to production. However i found i cannot delete the Faculty table because the foreign key. but i do not want to write down hundreds of update statement, and also cannot delete the Class data in production, how can i do if i want to copy  the Faculty table to production?</p>