Db\Dialect\Sqlite::listTables

public listTables ([mixed $schemaName]) List all tables in database print_r($dialect->listTables("blog"))

Db\Dialect\Sqlite::getColumnDefinition

public getColumnDefinition (Phalcon\Db\ColumnInterface $column) Gets the column name in SQLite

Db\Dialect\Sqlite::listViews

public listViews ([mixed $schemaName]) Generates the SQL to list all views of a schema or user

Db\Dialect\Sqlite::listIndexesSql

public listIndexesSql (mixed $table, [mixed $schema], [mixed $keyName]) Generates the SQL to get query list of indexes print_r($dialect->listIndexesSql("blog"))

Db\Dialect\Sqlite::dropView

public dropView (mixed $viewName, [mixed $schemaName], [mixed $ifExists]) Generates SQL to drop a view

Db\Dialect\Sqlite::dropColumn

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

Db\Dialect\Sqlite::dropPrimaryKey

public dropPrimaryKey (mixed $tableName, mixed $schemaName) Generates SQL to delete primary key from a table

Db\Dialect\Sqlite::dropTable

public dropTable (mixed $tableName, [mixed $schemaName], [mixed $ifExists]) Generates SQL to drop a table

Db\Dialect\Sqlite::dropForeignKey

public dropForeignKey (mixed $tableName, mixed $schemaName, mixed $referenceName) Generates SQL to delete a foreign key from a table

Db\Dialect\Sqlite::dropIndex

public dropIndex (mixed $tableName, mixed $schemaName, mixed $indexName) Generates SQL to delete an index from a table