Re: Using SQL to create script 2 create indx

From: Dennis Chebotarev <tdennis_at_iname.com>
Date: Thu, 05 Nov 1998 09:28:08 -0800
Message-ID: <3641E028.FA7B4042@iname.com>

Try USER_IND_COLUMNS, ALL_IND_COLUMNS or DBA_IND_COLUMNS (if you have access to last table).

Best regards,

Dennis.

Joe R Jurgena wrote:

> I am trying to put together a sql statement that will output a script that
> can be run to recreate an index.
> Tables were easy compared to an index. Where is the column(s) indexed info
> stored? Does any one have an example of this
> they would like to share?
>
> Thanks
> Joe
Received on Thu Nov 05 1998 - 11:28:08 CST