Interface **Phalcon\\Db\\DialectInterface**
===========================================

Phalcon\\Db\\DialectInterface initializer


Methods
---------

abstract public *string*  **limit** (*string* $sqlQuery, *int* $number)

Generates the SQL for LIMIT clause



abstract public *string*  **forUpdate** (*string* $sqlQuery)

Returns a SQL modified with a FOR UPDATE clause



abstract public *string*  **sharedLock** (*string* $sqlQuery)

Returns a SQL modified with a LOCK IN SHARE MODE clause



abstract public *string*  **select** (*array* $definition)

Builds a SELECT statement



abstract public *string*  **getColumnList** (*array* $columnList)

Gets a list of columns



abstract public  **getColumnDefinition** (:doc:`Phalcon\\Db\\ColumnInterface <Phalcon_Db_ColumnInterface>` $column)

Gets the column name in MySQL



abstract public *string*  **addColumn** (*string* $tableName, *string* $schemaName, :doc:`Phalcon\\Db\\ColumnInterface <Phalcon_Db_ColumnInterface>` $column)

Generates SQL to add a column to a table



abstract public *string*  **modifyColumn** (*string* $tableName, *string* $schemaName, :doc:`Phalcon\\Db\\ColumnInterface <Phalcon_Db_ColumnInterface>` $column)

Generates SQL to modify a column in a table



abstract public *string*  **dropColumn** (*string* $tableName, *string* $schemaName, *string* $columnName)

Generates SQL to delete a column from a table



abstract public *string*  **addIndex** (*string* $tableName, *string* $schemaName, :doc:`Phalcon\\Db\\IndexInterface <Phalcon_Db_IndexInterface>` $index)

Generates SQL to add an index to a table



abstract public *string*  **dropIndex** (*string* $tableName, *string* $schemaName, *string* $indexName)

Generates SQL to delete an index from a table



abstract public *string*  **addPrimaryKey** (*string* $tableName, *string* $schemaName, :doc:`Phalcon\\Db\\IndexInterface <Phalcon_Db_IndexInterface>` $index)

Generates SQL to add the primary key to a table



abstract public *string*  **dropPrimaryKey** (*string* $tableName, *string* $schemaName)

Generates SQL to delete primary key from a table



abstract public *string*  **addForeignKey** (*string* $tableName, *string* $schemaName, :doc:`Phalcon\\Db\\ReferenceInterface <Phalcon_Db_ReferenceInterface>` $reference)

Generates SQL to add an index to a table



abstract public *string*  **dropForeignKey** (*string* $tableName, *string* $schemaName, *string* $referenceName)

Generates SQL to delete a foreign key from a table



abstract public *string*  **createTable** (*string* $tableName, *string* $schemaName, *array* $definition)

Generates SQL to create a table



abstract public  **dropTable** (*unknown* $tableName, *unknown* $schemaName, *unknown* $ifExists)

Generates SQL to drop a table



abstract public *string*  **tableExists** (*string* $tableName, *string* $schemaName)

Generates SQL checking for the existence of a schema.table



abstract public *string*  **describeColumns** (*string* $table, *string* $schema)

Generates SQL to describe a table



abstract public *array*  **listTables** (*string* $schemaName)

List all tables on database



abstract public *string*  **describeIndexes** (*string* $table, *string* $schema)

Generates SQL to query indexes on a table



abstract public *string*  **describeReferences** (*string* $table, *string* $schema)

Generates SQL to query foreign keys on a table



abstract public *string*  **tableOptions** (*string* $table, *string* $schema)

Generates the SQL to describe the table creation options