public function getListTableForeignKeysSQL($table)
{
$table = $this->quoteStringLiteral($table);
return "SELECT fkcol.COLNAME AS local_column,\n fk.REFTABNAME AS foreign_table,\n pkcol.COLNAME AS foreign_column,\n fk.CONSTNAME AS index_name,\n CASE\n WHEN fk.UPDATERULE = 'R' THEN 'RESTRICT'\n ELSE NULL\n END AS on_update,\n CASE\n WHEN fk.DELETERULE = 'C' THEN 'CASCADE'\n WHEN fk.DELETERULE = 'N' THEN 'SET NULL'\n WHEN fk.DELETERULE = 'R' THEN 'RESTRICT'\n ELSE NULL\n END AS on_delete\n FROM SYSCAT.REFERENCES AS fk\n JOIN SYSCAT.KEYCOLUSE AS fkcol\n ON fk.CONSTNAME = fkcol.CONSTNAME\n AND fk.TABSCHEMA = fkcol.TABSCHEMA\n AND fk.TABNAME = fkcol.TABNAME\n JOIN SYSCAT.KEYCOLUSE AS pkcol\n ON fk.REFKEYNAME = pkcol.CONSTNAME\n AND fk.REFTABSCHEMA = pkcol.TABSCHEMA\n AND fk.REFTABNAME = pkcol.TABNAME\n WHERE fk.TABNAME = UPPER(" . $table . ")\n ORDER BY fkcol.COLSEQ ASC";
}