Login Register

db\pgsql\QueryBuilder dropIndex()

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.

Links:

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

doc_Yii

2016-10-30 16:58:45

Comments

Leave a Comment

Please login to continue.

Popular Articles

db\pgsql\QueryBuilder insert() insert() public method Creates an INSERT SQL statement. For example, $sql = $queryBuilder->insert('user', [ 'name' => 'Sam', 'age'

db\pgsql\QueryBuilder update() update() public method Creates an UPDATE SQL statement. For example, $params = []; $sql = $queryBuilder->update('user', ['status' => 1], 'a

db\pgsql\QueryBuilder createIndex() createIndex() public method Builds a SQL statement for creating a new index. See also http://www.postgresql.org/docs/8.2/static/sql-createindex.h

db\pgsql\QueryBuilder alterColumn() alterColumn() public method Builds a SQL statement for changing the definition of a column. public string alterColumn ( $table, $column, $type

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