Doctrine\DBAL\Platforms\DB2Platform::getListTableForeignKeysSQL PHP Method

getListTableForeignKeysSQL() public method

{@inheritDoc}
public getListTableForeignKeysSQL ( $table )
    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";
    }