Login Register

db\sqlite\QueryBuilder addPrimaryKey()

addPrimaryKey() public method

Builds a SQL statement for adding a primary key constraint to an existing table.

public string addPrimaryKey ( $name, $table, $columns )
$name	string	The name of the primary key constraint.
$table	string	The table that the primary key constraint will be added to.
$columns	string\|array	Comma separated string or array of columns that the primary key will consist of.
return	string	The SQL statement for adding a primary key constraint to an existing table.
throws	yii\base\NotSupportedException	this is not supported by SQLite

Links:

http://www.yiiframework.com/doc-2.0/yii-db-sqlite-querybuilder.html#addPrimaryKey()-detail

doc_Yii

2016-10-30 16:59:52

Comments

Leave a Comment

Please login to continue.

Popular Articles

db\sqlite\QueryBuilder addCommentOnTable() addCommentOnTable() public method (available since version 2.0.8) Builds a SQL command for adding comment to table public string addCommentOnTa

db\sqlite\QueryBuilder batchInsert() batchInsert() public method Generates a batch INSERT SQL statement. For example, $connection->createCommand()->batchInsert('user', ['name',

db\sqlite\QueryBuilder dropColumn() dropColumn() public method Builds a SQL statement for dropping a DB column. public string dropColumn ( $table, $column )$table string The tabl

db\sqlite\QueryBuilder dropPrimaryKey() dropPrimaryKey() public method Builds a SQL statement for removing a primary key constraint to an existing table. public string dropPrimaryKey

db\sqlite\QueryBuilder $typeMap $typeMap public property Mapping from abstract column types (keys) to physical column types (values). public array $typeMap = [\yii\db\sqlite\Sc