Question: Is it possible to retrieve specific table type (e.g. IOT)

schemacrawler / SchemaCrawler

Free database schema discovery and comprehension tool

http://www.schemacrawler.com/

Other

1.62k stars 200 forks source link

Question: Is it possible to retrieve specific table type (e.g. IOT) #254

Closed patric-r closed 5 years ago

patric-r commented 5 years ago

Question here (oracle specific).

Using schemacrawler, is it possible to determine whether a table is an index-organized-table (IOT)? Or to find all IOT within a schema?

Thank you.

sualeh commented 5 years ago

Using the API or command-line?

patric-r commented 5 years ago

API

sualeh commented 5 years ago

@patric-r - please see the commit that closes this issue. Until the next version of SchemaCrawler is released, you can take a similar approach to get information IOT tables.