dbGetTables

Purpose

Returns the database’s tables, system tables and views.

Format

tables = dbGetTables(db_id[, type])

Parameters:

• db_id (scalar) – database connection index number.

• type (string:) –

  Tables	All tables visible to the user. This is the default value.
  System Tables	Internal tables used by the database.
  Views	All views visible to the user.
  All	All of the above.

Returns:

tables (Nx1 string array) – Contains the information specified by the type parameter.

Examples

// Add MySQL to the list of database connections
db_id = dbAddDatabase("MYSQL");
dbSetDatabaseName(db_id, "mydb");
dbOpen(db_id);

// Get all user tables
tables = dbGetTables(db_id);
print tables;

// Get all views
views = dbGetTables(db_id, "Views");
print views;