Re: Code to Save & Recreate Indexes
In article <Pine.SUN.3.91.960919141134.21833A-100000@tyrell.net>,
Daniel Martin <drmartin@tyrell.net> wrote:
>
>Below is a way I used to save Index info for an entire database.
>
I think there could be a simpler way to do the job, using the dbschema utility
provided by INFORMIX. Possible shell script follows
:
# script to extract create.sql and drop.sql to drop all indexes and then
# recreate them
# First, create.sql
dbschema -d beams | grep -y 'create index' > create.sql
# Next, drop.sql
sed "s/^create/drop/" create.sql | sed "s/ on .*/;/" > drop.sql
# End of script.
Rudy Fernandes
Gulf Insurance Co, Kuwait.