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

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

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

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

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

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

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

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

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

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