Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2008
    Posts
    5

    Unanswered: To List all indexes in a database?

    Hi All,

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


    thanks in advance!!!!!!!!

  2. #2
    Join Date
    Nov 2008
    Posts
    65
    Provided Answers: 1
    How about
    select idxname from sysindexes;

    HTH

  3. #3
    Join Date
    Sep 2008
    Posts
    5
    thank you very much !!!!!!!!!!!!!!!!!

  4. #4
    Join Date
    Sep 2008
    Posts
    5
    but one more thing!

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

  5. #5
    Join Date
    Nov 2008
    Posts
    65
    Provided Answers: 1
    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

  6. #6
    Join Date
    Sep 2008
    Posts
    5

    using dbaccess utility....

    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!!!!!!!!!!!

  7. #7
    Join Date
    Nov 2008
    Posts
    65
    Provided Answers: 1
    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

  8. #8
    Join Date
    Sep 2008
    Posts
    5
    thanks sir!!!!!!!!!!!!!
    it is very help full

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •