public function getListTableForeignKeysSQL($table)
{
$table = $this->normalizeIdentifier($table);
$table = $this->quoteStringLiteral($table->getName());
return "SELECT alc.constraint_name,\n alc.DELETE_RULE,\n cols.column_name \"local_column\",\n cols.position,\n (\n SELECT r_cols.table_name\n FROM user_cons_columns r_cols\n WHERE alc.r_constraint_name = r_cols.constraint_name\n AND r_cols.position = cols.position\n ) AS \"references_table\",\n (\n SELECT r_cols.column_name\n FROM user_cons_columns r_cols\n WHERE alc.r_constraint_name = r_cols.constraint_name\n AND r_cols.position = cols.position\n ) AS \"foreign_column\"\n FROM user_cons_columns cols\n JOIN user_constraints alc\n ON alc.constraint_name = cols.constraint_name\n AND alc.constraint_type = 'R'\n AND alc.table_name = " . $table . "\n ORDER BY cols.constraint_name ASC, cols.position ASC";
}