Retrieves a list of fields from a table schema.
The returned list is suitable for use in an SQL query.
$table: The name of the table from which to retrieve fields.
An optional prefix to to all fields.:
An array of fields.
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;
}
}