Index Creation Script

Can anybody point me to a script that will output an index creation script by querying an existing index?

I'd like to run a block which builds a 'CREATE INDEX' script, drop the index and recreates the script.

-greg

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!