Re: Creating a table with same structure than another

[Dan Nelson]

In the last episode (Feb 22), Dax Mickelson said:
> Will create table foo select * from bar create the column structure
> AND copy over the data?  (i.e.  Could this be used to make a backup
> table?)

Yes, it'll copy the data over.  If all you want is the same field
definitions, use "create table foo select * from bar where 1=0".  If
you want the same indexes on the new table, you'll have to manually
create them.

-- 
	Dan Nelson
	dnelson@stripped