/** * Get all indexed columns * * returns an array with all columns that make use of an index * * e.g. index(col1, col2) would return col1, col2 * * @param bool $backquoted whether to quote name with backticks `` * @param bool $fullName whether to include full name of the table as a prefix * * @return array */ public function getIndexedColumns($backquoted = true, $fullName = true) { $sql = $this->_dbi->getTableIndexesSql($this->getDbName(), $this->getName(), ''); $indexed = $this->_dbi->fetchResult($sql, 'Column_name', 'Column_name'); $return = array(); foreach ($indexed as $column) { $return[] = ($fullName ? $this->getFullName($backquoted) . '.' : '') . ($backquoted ? Util::backquote($column) : $column); } return $return; }
/** * Get all indexed columns * * returns an array with all columns that make use of an index * * e.g. index(col1, col2) would return col1, col2 * * @param bool $backquoted whether to quote name with backticks `` * @param bool $fullName whether to include full name of the table as a prefix * * @return array */ public function getIndexedColumns($backquoted = true, $fullName = true) { $sql = $this->_dbi->getTableIndexesSql($this->getDbName(), $this->getName(), ''); $indexed = $this->_dbi->fetchResult($sql, 'Column_name', 'Column_name'); return $this->_formatColumns($indexed, $backquoted, $fullName); }