Child pages
  • Extract Raw Tables from Database

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

'Extract Raw Tables from Database' lets you explore the raw contents of a database, extracting every table in the database into the Data Manager.

Usage Hints

'Extract Raw Tables from Database' is useful when you need to view or process the raw database contents. This can be helpful when writing custom database queries (see Custom Table Query and Custom Graph Query)), in conjunction with the database schema, which you can view by right-clicking a database and selecting "View".

Note that table names and other internal database details are maintained only for internal use, and may at times seem counter-intuitive: for instance, the table 'AUTHORS' in an ISI database is not a table of authors, but a relationship table that maps a person in the 'PERSON' table to a paper in the 'DOCUMENT' table (as in the sentence "fred authors the scientific paper").

Implementation Details

This algorithm performs a 'SELECT *' query on every non-system database table in the selected database.