Db\Dialect\Sqlite::describeReferences

public describeReferences (mixed $table, [mixed $schema]) Generates SQL to query foreign keys on a table

Db\Dialect\Sqlite::describeIndexes

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

Db\Dialect\Sqlite::describeIndex

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

Db\Dialect\Sqlite::describeColumns

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

Db\Dialect\Sqlite::createView

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

Db\Dialect\Sqlite::createTable

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

Db\Dialect\Sqlite::addPrimaryKey

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

Db\Dialect\Sqlite::addIndex

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

Db\Dialect\Sqlite::addForeignKey

public addForeignKey (mixed $tableName, mixed $schemaName, Phalcon\Db\ReferenceInterface $reference) Generates SQL to add an index to a table

Db\Dialect\Sqlite::addColumn

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