how to clone a table?

From: <>
Date: Thu, 21 Aug 2008 20:34:30 GMT
Message-ID: <qjkrk.4768$>

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 Harrison
Pixar Animation Studios
Received on Thu Aug 21 2008 - 15:34:30 CDT

Original text of this message