checkIntegrity() public method Builds a SQL statement for enabling or disabling 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. Defaults to empty string, meaning the current or default schema. $table string The table name. Defaults to empty string, meaning that no table will be changed. return string The SQL statement for checking integrit

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

buildOrderByAndLimit() public method Builds the ORDER BY and LIMIT/OFFSET clauses and appends them to the given SQL. public string buildOrderByAndLimit ( $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.

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

alterColumn() public method Builds a SQL statement for changing the definition of a column. public string alterColumn ( $table, $column, $type )$table string The table whose column is to be changed. The table name will be properly quoted by the method. $column string The name of the column to be changed. The name will be properly quoted by the method. $type string The new column type. The getColumnType() method will be invoked to convert abstract column type (if any) into the physica

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

addCommentOnColumn() public method (available since version 2.0.8) Builds a SQL command for adding comment to column public string addCommentOnColumn ( $table, $column, $comment )$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. $comment string The text of the comment to be added. The comment will be properly quoted

$typeMap public property Mapping from abstract column types (keys) to physical column types (values). public array $typeMap = [\yii\db\mssql\Schema::TYPE_PK => 'int IDENTITY PRIMARY KEY', \yii\db\mssql\Schema::TYPE_UPK => 'int IDENTITY PRIMARY KEY', \yii\db\mssql\Schema::TYPE_BIGPK => 'bigint IDENTITY PRIMARY KEY', \yii\db\mssql\Schema::TYPE_UBIGPK => 'bigint IDENTITY PRIMARY KEY', \yii\db\mssql\Schema::TYPE_CHAR => 'nchar(1)', \yii\db\mssql\Schema::TYPE_STRING => 'nvarch

rollBack() public method Rollbacks a transaction. It is necessary to override PDO's method as MSSQL PDO driver does not natively support transactions. public boolean rollBack ( )return boolean The result of a transaction roll back.

lastInsertId() public method Returns value of the last inserted ID. public integer lastInsertId ( $sequence = null )$sequence string|null The sequence name. Defaults to null. return integer Last inserted ID value.