[GENERAL] creating a table from another table

[David O'Farrell]

-- is there any smart way to duplicate a table definition (NOT the
data in the table).I want to create table(s) from a predefined template 
and drop them when they are empty .




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  David O'Farrell                              AerSoft Limited        
  mailto:[EMAIL PROTECTED]              2 Northumberland Avenue,
                                               Dun Laoghaire,Co. Dublin
        Direct Phone 353-1-2145950
               Phone: 01-2301166   Fax: 01-2301167
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~