dropForeignKey() public method Builds a SQL statement for dropping a foreign key constraint. public string dropForeignKey ( $name, $table )$name string The name of the foreign key constraint to be dropped. The name will be properly quoted by the method. $table string The table whose foreign is to be dropped. The name will be properly quoted by the method. return string The SQL statement for dropping a foreign key constraint. throws yii\base\NotSupportedException this is not support

dropCommentFromTable() public method (available since version 2.0.8) Builds a SQL command for adding comment to table public string dropCommentFromTable ( $table )$table string The table whose column is to be commented. The table name will be properly quoted by the method. return string The SQL statement for adding comment on column throws yii\base\NotSupportedException

dropCommentFromColumn() public method (available since version 2.0.8) Builds a SQL command for adding comment to column public string dropCommentFromColumn ( $table, $column )$table string The table whose column is to be commented. The table name will be properly quoted by the method. $column string The name of the column to be commented. The column name will be properly quoted by the method. return string The SQL statement for adding comment on column throws yii\base\NotSupportedEx

dropColumn() public method Builds a SQL statement for dropping a DB column. public string dropColumn ( $table, $column )$table string The table whose column is to be dropped. The name will be properly quoted by the method. $column string The name of the column to be dropped. The name will be properly quoted by the method. return string The SQL statement for dropping a DB column. throws yii\base\NotSupportedException this is not supported by SQLite

checkIntegrity() public method Enables or disables integrity check. public string checkIntegrity ( $check = true, $schema = '', $table = '' )$check boolean Whether to turn on or off the integrity check. $schema string The schema of the tables. Meaningless for SQLite. $table string The table name. Meaningless for SQLite. return string The SQL statement for checking integrity throws yii\base\NotSupportedException this is not supported by SQLite

buildUnion() public method public string buildUnion ( $unions, &$params )$unions array $params array The binding parameters to be populated return string The UNION clause built from yii\db\Query::$union.

buildSubqueryInCondition() protected method Builds SQL for IN condition protected string buildSubqueryInCondition ( $operator, $columns, $values, &$params )$operator string $columns array $values yii\db\Query $params array return string SQL throws yii\base\NotSupportedException if $columns is an array

buildLimit() public method public string buildLimit ( $limit, $offset )$limit integer $offset integer return string The LIMIT and OFFSET clauses

buildCompositeInCondition() protected method Builds SQL for IN condition protected string buildCompositeInCondition ( $operator, $columns, $values, &$params )$operator string $columns array $values array $params array return string SQL

build() public method Generates a SELECT SQL statement from a yii\db\Query object. public array build ( $query, $params = [] )$query yii\db\Query The yii\db\Query object from which the SQL statement will be generated. $params array The parameters to be bound to the generated SQL statement. These parameters will be included in the result with the additional parameters generated during the query building process. return array The generated SQL statement (the first array element) and th