Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2007
    Posts
    2

    Unanswered: List table index and dbspace location

    Does anyone has a sql that will list all the tables and index the tables has and the dbspace location of table/index

    thanks

  2. #2
    Join Date
    Jul 2007
    Posts
    2
    `dbschema -d DATABASENAME -ss > FILENAME`
    this command lists all the tables and their indexes and dbspace information in your DATABASENAME (server info) and will write it to FILENAME. Type `dbschema --` to see help for this.

Posting Permissions

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