creating a table from another table

-- 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:dave(dot)ofarrell(at)aersoft(dot)ie 2 Northumberland Avenue,
Dun Laoghaire,Co. Dublin
Direct Phone 353-1-2145950
Phone: 01-2301166 Fax: 01-2301167
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~