RE: Safe way to drop and re-create table?
Posted in 1999
Topics: Stored Procedures & SPL
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
------------------------------------------------------------