function chado_get_custom_table_names

2.x tripal_core.custom_tables.api.inc chado_get_custom_table_names($include_mview = TRUE)
3.x tripal_chado.custom_tables.api.inc chado_get_custom_table_names($include_mview = TRUE)

Retrieves the list of custom tables in this site.

@returns An associative array where the key and value pairs are the table names.

Related topics

File

tripal_core/api/tripal_core.custom_tables.api.inc, line 296
Provides an API to manage custom tables in Chado.

Code

function chado_get_custom_table_names($include_mview = TRUE) {

  $sql = "SELECT table_name FROM {tripal_custom_tables}";
  if (!$include_mview) {
    $sql .= " WHERE mview_id IS NULL";
  }
  $resource = db_query($sql);

  foreach ($resource as $r) {
    $tables[$r->table_name] = $r->table_name;
  }

  asort($tables);
  return $tables;
}