createQueryBuilder() public method Creates a query builder for the MySQL database. This method may be overridden by child classes to create a DBMS-specific query builder. public yii\db\sqlite\QueryBuilder createQueryBuilder ( )return yii\db\sqlite\QueryBuilder Query builder instance

createColumnSchemaBuilder() public method Create a column schema builder instance giving the type and value precision. This method may be overridden by child classes to create a DBMS-specific column schema builder. public yii\db\sqlite\ColumnSchemaBuilder createColumnSchemaBuilder ( $type, $length = null )$type string Type of the column. See yii\db\sqlite\ColumnSchemaBuilder::$type. $length integer|string|array Length or precision of the column. See yii\db\sqlite\ColumnSchemaBuilder:

$typeMap public property Mapping from physical column types (keys) to abstract column types (values) public array $typeMap = ['tinyint' => self::TYPE_SMALLINT, 'bit' => self::TYPE_SMALLINT, 'boolean' => self::TYPE_BOOLEAN, 'bool' => self::TYPE_BOOLEAN, 'smallint' => self::TYPE_SMALLINT, 'mediumint' => self::TYPE_INTEGER, 'int' => self::TYPE_INTEGER, 'integer' => self::TYPE_INTEGER, 'bigint' => self::TYPE_BIGINT, 'float' => self::TYPE_FLOAT, 'double' => self

$transactionIsolationLevel public write-only property The transaction isolation level to use for this transaction. This can be either yii\db\Transaction::READ_UNCOMMITTED or yii\db\Transaction::SERIALIZABLE. public void setTransactionIsolationLevel ( $level )

truncateTable() public method Builds a SQL statement for truncating a DB table. public string truncateTable ( $table )$table string The table to be truncated. The name will be properly quoted by the method. return string The SQL statement for truncating a DB table.

resetSequence() public method Creates a SQL statement for resetting the sequence value of a table's primary key. The sequence will be reset such that the primary key of the next new row inserted will have the specified value or 1. public string resetSequence ( $tableName, $value = null )$tableName string The name of the table whose primary key sequence will be reset $value mixed The value for the primary key of the next new row inserted. If this is not set, the next new row's primary k

renameTable() public method Builds a SQL statement for renaming a DB table. public string renameTable ( $table, $newName )$table 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. throws y

dropPrimaryKey() public method Builds a SQL statement for removing a primary key constraint to an existing table. public string dropPrimaryKey ( $name, $table )$name string The name of the primary key constraint to be removed. $table string The table that the primary key constraint will be removed from. return string The SQL statement for removing a primary key constraint from an existing table. throws yii\base\NotSupportedException this is not supported by SQLite

dropIndex() public method Builds a SQL statement for dropping an index. public string dropIndex ( $name, $table )$name string The name of the index to be dropped. The name will be properly quoted by the method. $table string The table whose index is to be dropped. The name will be properly quoted by the method. return string The SQL statement for dropping an index.