Emerald Database Problem

Admin ( (no email) )
Mon, 31 Aug 1998 10:56:15 -0500

I need to Shrink the size of by Emerald Database I am running out of hard
drive because of my database backups. Currently I have 1.4 Gig setup but I
am using less that 250 Megs of that. If I use the Shrink Command in the Edit
Database Window of the SQL Exec all of the databases Indexes will need to
be rebuilt be cause they will not be valid.

My question is where or how can I get the SQL code that was used to create
those Indexes so I can reindex the database after it is shrank.

Darryl Etter