Hi All,

How to list all indexes names in a particular database(ex: v001)?


thanks in advance!!!!!!!!

How about

select idxname from sysindexes;

HTH

thank you very much !!!!!!!!!!!!!!!!!

but one more thing!

how to export the result of this query to a file?

Depends which tool you are using.
If you are using dbaccess, in query menu you have output option where you can set output to go to new-file, append-file, printer, ...
HTH

Hi,

i am learning IDS. can you please send details steps to export the output to a file. i am using dbaccess utility....

thanks once again!!!!!!!!!!!

Type:

dbaccess your_database_name (of course replace your_database_name with name of your database)

Press "Q" (without quotes, of course - Q stands for "query-language")
Press "N" (without quotes, of course - N stands for "new")
Type in your query. For example:

select idxname from sysindexes;

After you are finished with query press ESC (escape key)
Press "O" (without quotes, of course - O stands for "output")
Press "N" (without quotes, of course - N stands for "new-file" - you have to be carefule because if file exists it'll be overwritten)
Type in file name, for example:
my_first_output_file
Press Enter key when finished
Press "R" (without quotes, of course - R stands for "run")
Press twice "E" (without quotes, of course - E stands for "exit")
And you're back in OS an you have your file.
HTH

thanks sir!!!!!!!!!!!!!
it is very help full