$defaultSchema public property The default schema used for the current session. public string $defaultSchema = 'dbo'

selectExists() public method (available since version 2.0.8) Creates a SELECT EXISTS() SQL statement. public string selectExists ( $rawSql )$rawSql string The subquery in a raw form to select from. return string The SELECT EXISTS() SQL statement.

renameTable() public method Builds a SQL statement for renaming a DB table. public string renameTable ( $oldName, $newName )$oldName string The table to be renamed. The name will be properly quoted by the method. $newName string The new table name. The name will be properly quoted by the method. return string The SQL statement for renaming a DB table.

renameColumn() public method Builds a SQL statement for renaming a column. public string renameColumn ( $table, $oldName, $newName )$table string The table whose column is to be renamed. The name will be properly quoted by the method. $oldName string The old name of the column. The name will be properly quoted by the method. $newName string The new name of the column. The name will be properly quoted by the method. return string The SQL statement for renaming a DB column.

oldBuildOrderByAndLimit() protected method Builds the ORDER BY/LIMIT/OFFSET clauses for SQL SERVER 2005 to 2008. protected string oldBuildOrderByAndLimit ( $sql, $orderBy, $limit, $offset )$sql string The existing SQL (without ORDER BY/LIMIT/OFFSET) $orderBy array The order by columns. See \yii\db\mssql\Query::orderBy for more details on how to specify this parameter. $limit integer The limit number. See \yii\db\mssql\Query::limit for more details. $offset integer The offset number

newBuildOrderByAndLimit() protected method Builds the ORDER BY/LIMIT/OFFSET clauses for SQL SERVER 2012 or newer. protected string newBuildOrderByAndLimit ( $sql, $orderBy, $limit, $offset )$sql string The existing SQL (without ORDER BY/LIMIT/OFFSET) $orderBy array The order by columns. See \yii\db\mssql\Query::orderBy for more details on how to specify this parameter. $limit integer The limit number. See \yii\db\mssql\Query::limit for more details. $offset integer The offset numbe

isOldMssql() protected method protected boolean isOldMssql ( )return boolean Whether the version of the MSSQL being used is older than 2012. throws yii\base\InvalidConfigException throws yii\db\Exception

getAllColumnNames() protected method Returns an array of column names given model name protected array|null getAllColumnNames ( $modelClass = null )$modelClass string Name of the model class return array|null Array of column names

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

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