Re: recovering the create string for index or table?

ferhat haydar a écrit :

> Does anybody know what is the documented way to
> recover the original SQL statement which was used to create a table or
> index?
>
> Say I know that there is an index called DUMMY.
> How can I programatically recover the string that created it?
>
> Thanks in advance.

You can find all that you want in these (system) views :

ALL_INDEXES and ALL_IND_COLUMNS
(or USER_INDEXES and USER_IND_COLUMNS
 or DBA_INDEXES and DBA_IND_COLUMNS)

Pierre Received on Mon Jan 17 2000 - 05:56:39 CST