Hi,
It seems as if a CREATE TABLES AS does not duplicate the table constraints.
How can I enforce this. I need the fastest possible way to make an exact copy
of a table. This is to support the administrative mechanism in an app where
changes are made to a mirrored copy of a set of tables first and when happy,
these are copied to the operational tables.
Regards
Tiaan