Safe way to drop and re-create table?

7.3x, unix I want to do the following save a table schema drop it recreate it without indexes populate the table create the indexes I'm thinking of doing it by doing a dbschema to a text file, splitting the file into two SQL files : 1. "the bit before the first create index statement" 2. "the bit from and including the first create index statement" Then use these sql files in the appropriate steps outlined above. Does this sound like a good/safe approach? Is there a better one? Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.