db\mssql\Schema loadColumnSchema()

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

db\mssql\Schema findUniqueIndexes()

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.

db\mssql\Schema findTableNames()

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.

db\mssql\Schema findTableConstraints()

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

db\mssql\Schema findPrimaryKeys()

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

db\mssql\Schema findForeignKeys()

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

db\mssql\Schema findColumns()

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

db\mssql\Schema createSavepoint()

createSavepoint() public method Creates a new savepoint. public void createSavepoint ( $name )$name string The savepoint name

db\mssql\Schema createQueryBuilder()

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.

db\mssql\Schema $typeMap

$typeMap public property Mapping from physical column types (keys) to abstract column types (values) 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::