Re: Copying tables

I would use one of two ways... [I haven't done any benchmarking, so I don't know which is faster, but this should only be a few seconds either way...]

create table_a as select * from table_b where 1 = 2;

or

export tables=(table_a)
import rows=n

hope this helpse

cemail_at_sprintmail.com wrote:

> I want to copy Table A and all of its constraints and name it
> Table B. Don't want to copy the data though. What is the easiest
> way to do this?
Received on Tue Oct 03 2000 - 19:07:00 CDT