function drupal_schema_fields_sql

Retrieves a list of fields from a table schema.

The returned list is suitable for use in an SQL query.

Parameters

string $table: The name of the table from which to retrieve fields.

string $prefix: An optional prefix to to all fields.

Return value

array An array of fields.

Related topics

Schema API
API to handle database schemas.
1 call to drupal_schema_fields_sql()
EntityManager::processDefinition in drupal/core/lib/Drupal/Core/Entity/EntityManager.php
Overrides Drupal\Component\Plugin\PluginManagerBase::processDefinition().

File

drupal/core/includes/schema.inc, line 343
Schema API handling functions.

Code

function drupal_schema_fields_sql($table, $prefix = NULL) {
  $schema = drupal_get_schema($table);
  $fields = array_keys($schema['fields']);
  if ($prefix) {
    $columns = array();
    foreach ($fields as $field) {
      $columns[] = "{$prefix}.{$field}";
    }
    return $columns;
  }
  else {
    return $fields;
  }
}