how to clone a table?
From: <mh_at_pixar.com>
Date: Thu, 21 Aug 2008 20:34:30 GMT
Message-ID: <qjkrk.4768$zv7.2725@flpi143.ffdc.sbc.com>
Date: Thu, 21 Aug 2008 20:34:30 GMT
Message-ID: <qjkrk.4768$zv7.2725@flpi143.ffdc.sbc.com>
I have a table MASTER_DEF_TBL and would like to replicate its
definition (including constraints, indexes, comments, etc) to several
tables such as MY_DEF_TBL and YOUR_DEF_TBL.
What's the best way to do this? Is there a table clone command, or some way to inherit from another table?
Many TIA!
Mark
-- Mark Harrison Pixar Animation StudiosReceived on Thu Aug 21 2008 - 15:34:30 CDT