public array fetchAll (string $sqlQuery, [int $fetchMode], [array $bindParams], [array $bindTypes]) Dumps the complete result of a query into an array //Getting all robots with associative indexes only $robots = $connection->fetchAll("SELECT * FROM robots", Phalcon\Db::FETCH_ASSOC); foreach ($robots as $robot) { print_r($robot); } //Getting all robots that contains word "robot" withing the name $robots = $connection->fetchAll("SELECT * FROM robots WHERE name LIKE :name", Phal

public dropView (mixed $viewName, [mixed $schemaName], [mixed $ifExists]) Drops a view

public dropTable (mixed $tableName, [mixed $schemaName], [mixed $ifExists]) Drops a table from a schema/database

public dropPrimaryKey (mixed $tableName, mixed $schemaName) Drops a table’s primary key

public dropIndex (mixed $tableName, mixed $schemaName, mixed $indexName) Drop an index from a table

public dropForeignKey (mixed $tableName, mixed $schemaName, mixed $referenceName) Drops a foreign key from a table

public dropColumn (mixed $tableName, mixed $schemaName, mixed $columnName) Drops a column from a table

public describeReferences (mixed $table, [mixed $schema]) Lists table references print_r($connection->describeReferences('robots_parts'));

public Phalcon\Db\Index[] describeIndexes (string $table, [string $schema]) Lists table indexes print_r($connection->describeIndexes('robots_parts'));

public boolean delete (string | array $table, [string $whereCondition], [array $placeholders], [array $dataTypes]) Deletes data from a table using custom RBDM SQL syntax //Deleting existing robot $success = $connection->delete( "robots", "id = 101" ); //Next SQL sentence is generated DELETE FROM `robots` WHERE `id` = 101