Row-chained Tables

Hi,

Here's the problem.

I have a table which is 90% chained, there is no point really do delete those rows and then insert them back. What I would think would be appropriate is dropping the table and recreating it (something like create table2 as select * from table1)
drop table1
alter database rename .... (or whatever the syntax is), but then again, there is a problem with constraints.

Thanx Received on Wed Jul 28 1999 - 17:11:45 CDT