public dropColumn (mixed $tableName, mixed $schemaName, mixed $columnName) Generates SQL to delete a column from a table

public addIndex (mixed $tableName, mixed $schemaName, Phalcon\Db\IndexInterface $index) Generates SQL to add an index to a table

public createTable (mixed $tableName, mixed $schemaName, array $definition) Generates SQL to create a table

public describeColumns (mixed $table, [mixed $schema]) Generates SQL describing a table print_r($dialect->describeColumns("posts"));

public describeIndex (mixed $index) Generates SQL to query indexes detail on a table

public createView (mixed $viewName, array $definition, [mixed $schemaName]) Generates SQL to create a view

public addPrimaryKey (mixed $tableName, mixed $schemaName, Phalcon\Db\IndexInterface $index) Generates SQL to add the primary key to a table

public describeIndexes (mixed $table, [mixed $schema]) Generates SQL to query indexes on a table

extends abstract class Phalcon\Db\Dialect implements Phalcon\Db\DialectInterface Source on GitHub Generates database specific SQL for the Sqlite RDBMS Methods public getColumnDefinition (Phalcon\Db\ColumnInterface $column) Gets the column name in SQLite public addColumn (mixed $tableName, mixed $schemaName, Phalcon\Db\ColumnInterface $column) Generates SQL to add a column to a table public modifyColumn (mixed $tableName, mixed $schemaName, Phalcon\Db\ColumnInterface $column, [Phalcon\Db\ColumnI

public addColumn (mixed $tableName, mixed $schemaName, Phalcon\Db\ColumnInterface $column) Generates SQL to add a column to a table