Hi All,
I have a situation on my hands. I renamed a table that corrupt data,
regenerated it from SQL and repopulated it with "good" data. Unfortunately,
unbeknownst to me, the renaming of the original table caused all the
triggers and views associated with the table to be modified.
I am thinking of renaming the new table that was generated to tablename_temp
and renaming the original back to tablename, truncating the table and using
select into to repopulate it. How dangerous is this? Is there another way?
TIA,
Duane
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
