/** * Get list of foreign keys for DB Table * * @param string $dbTable * @return array */ public function getForeignKeys($dbTable) { $dbConfig = $this->_db->getConfig(); $sql = $this->_db->select()->from($this->_db->quoteIdentifier('information_schema.TABLE_CONSTRAINTS'))->where('`CONSTRAINT_SCHEMA` =?', $dbConfig['dbname'])->where('`TABLE_SCHEMA` =?', $dbConfig['dbname'])->where('`TABLE_NAME` =?', $dbTable)->where('`CONSTRAINT_TYPE` = "FOREIGN KEY"'); return $this->_db->fetchAll($sql); }