/**
* 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);
}
