RE: Safe way to drop and re-create table?

One thing to watch out for, dbschema will not give you views or constraints which refer to this table. These things go away when you drop a table. Make sure you have all that information for recreation as well. Of course if neither of those things apply to the table, dbschema works great Will > > > > >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. ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, a free web-based service from Opera Software, makers of the award-winning Web Browser - http://www.operasoftware.com ------------------------------------------------------------