As per my understanding, there may be a situation when you just want to create an exact copy or clone of an existing table(i.e pc_work) to test or perform something without affecting the original table(new table:pc_work_ExternalInsert). If no, Could you elaborate more on your requirement?
If yes, I have reviewed the SQL query shared. I could observe multiple anomalies in the DROP command as well as CREATE command.
On first observation, there isn't any "CASCADE" keyword while executing "DROP" command(Query used:
DROP TABLE personaledition.pc_work_ExternalInsert;).
Ideally, it should work, as DROP TABLE always removes any indexes, rules, triggers, and constraints that exist for the target table. However, to drop a table that is referenced by a view or a foreign-key constraint of another table, CASCADE must be specified. (CASCADE will remove a dependent view entirely, but in the foreign-key case it will only remove the foreign-key constraint, not the other table entirely.)