Re: copy table structure

[Dan Nelson]

In the last episode (Sep 22), Balazs Wellisch said:
> Can anyone tell me how to copy a table structure? Not the data but the
> structure itself. I'm sure it's a function of CREATE TABLE somehow, but
> what's the exact syntax? I couldn't find it in the documentation.

Try something like "create table newtable select * from oldtable where
1=0".  You'll have to build the indexes yourself.

-- 
	Dan Nelson
	dnelson@stripped