Class yii\db\mssql\Schema

public string $defaultSchema = 'dbo'

public array $typeMap = ['bigint' => self::TYPE_BIGINT, 'numeric' => self::TYPE_DECIMAL, 'bit' => self::TYPE_SMALLINT, 'smallint' => self::TYPE_SMALLINT, 'decimal' => self::TYPE_DECIMAL, 'smallmoney' => self::TYPE_MONEY, 'int' => self::TYPE_INTEGER, 'tinyint' => self::TYPE_SMALLINT, 'money' => self::TYPE_MONEY, 'float' => self::TYPE_FLOAT, 'double' => self::TYPE_DOUBLE, 'real' => self::TYPE_FLOAT, 'date' => self::TYPE_DATE, 'datetimeoffset' => self::TYPE_DATETIME, 'datetime2' => self::TYPE_DATETIME, 'smalldatetime' => self::TYPE_DATETIME, 'datetime' => self::TYPE_DATETIME, 'time' => self::TYPE_TIME, 'char' => self::TYPE_CHAR, 'varchar' => self::TYPE_STRING, 'text' => self::TYPE_TEXT, 'nchar' => self::TYPE_CHAR, 'nvarchar' => self::TYPE_STRING, 'ntext' => self::TYPE_TEXT, 'binary' => self::TYPE_BINARY, 'varbinary' => self::TYPE_BINARY, 'image' => self::TYPE_BINARY, 'timestamp' => self::TYPE_TIMESTAMP, 'hierarchyid' => self::TYPE_STRING, 'uniqueidentifier' => self::TYPE_STRING, 'sql_variant' => self::TYPE_STRING, 'xml' => self::TYPE_STRING, 'table' => self::TYPE_STRING]

createQueryBuilder() public method

Creates a query builder for the MSSQL database.

public yii\db\mssql\QueryBuilder createQueryBuilder ( )
return	yii\db\mssql\QueryBuilder	Query builder interface.

createSavepoint() public method

Creates a new savepoint.

public void createSavepoint ( $name )
$name	string	The savepoint name

findColumns() protected method

Collects the metadata of table columns.

protected boolean findColumns ( $table )
$table	yii\db\mssql\TableSchema	The table metadata
return	boolean	Whether the table exists in the database

findForeignKeys() protected method

Collects the foreign key column details for the given table.

protected void findForeignKeys ( $table )
$table	yii\db\mssql\TableSchema	The table metadata

findPrimaryKeys() protected method

Collects the primary key column details for the given table.

protected void findPrimaryKeys ( $table )
$table	yii\db\mssql\TableSchema	The table metadata

findTableConstraints() protected method (available since version 2.0.4)

Collects the constraint details for the given table and constraint type.

protected array findTableConstraints ( $table, $type )
$table	yii\db\mssql\TableSchema
$type	string	Either PRIMARY KEY or UNIQUE
return	array	Each entry contains index_name and field_name

findTableNames() protected method

Returns all table names in the database.

protected array findTableNames ( $schema = '' )
$schema	string	The schema of the tables. Defaults to empty string, meaning the current or default schema.
return	array	All table names in the database. The names have NO schema name prefix.

findUniqueIndexes() public method (available since version 2.0.4)

Returns all unique indexes for the given table.

Each array element is of the following structure:

[
    'IndexName1' => ['col1' [, ...]],
    'IndexName2' => ['col2' [, ...]],
]

public array findUniqueIndexes ( $table )
$table	yii\db\mssql\TableSchema	The table metadata
return	array	All unique indexes for the given table.

findViewNames() protected method

protected void findViewNames ( $schema = '' )
$schema

loadColumnSchema() protected method

Loads the column information into a yii\db\ColumnSchema object.

protected yii\db\ColumnSchema loadColumnSchema ( $info )
$info	array	Column information
return	yii\db\ColumnSchema	The column schema object

loadTableSchema() public method

Loads the metadata for the specified table.

public yii\db\mssql\TableSchema|null loadTableSchema ( $name )
$name	string	Table name
return	yii\db\mssql\TableSchema|null	Driver dependent table metadata. Null if the table does not exist.

quoteSimpleColumnName() public method

Quotes a column name for use in a query.

A simple column name has no prefix.

public string quoteSimpleColumnName ( $name )
$name	string	Column name.
return	string	The properly quoted column name.

quoteSimpleTableName() public method

Quotes a table name for use in a query.

A simple table name has no schema prefix.

public string quoteSimpleTableName ( $name )
$name	string	Table name.
return	string	The properly quoted table name.

releaseSavepoint() public method

Releases an existing savepoint.

public void releaseSavepoint ( $name )
$name	string	The savepoint name

resolveTableNames() protected method

Resolves the table name and schema name (if any).

protected void resolveTableNames ( $table, $name )
$table	yii\db\mssql\TableSchema	The table metadata object
$name	string	The table name

rollBackSavepoint() public method

Rolls back to a previously created savepoint.

public void rollBackSavepoint ( $name )
$name	string	The savepoint name