Query\Drivers\Sqlite\SQL

SQLite Specific SQL

Synopsis

class SQL extends AbstractSQL {

• // methods
• public string explain()
• public string random()
• public string dbList()
• public string tableList()
• public array systemTableList()
• public string viewList()
• public string triggerList()
• public string functionList()
• public string procedureList()
• public string sequenceList()
• public array typeList()
• public string columnList()
• public string fkList()
• public string indexList()
• // Inherited methods from AbstractSQL
• public string limit()
}


Hierarchy

Extends

• Query\Drivers\AbstractSQL

Methods

public

• columnList() — SQL to show information about columns in a table
• dbList() — Returns sql to list other databases. Meaningless for SQLite, as this just returns the database(s) that we are currently connected to.
• explain() — Get the query plan for the sql query
• fkList() — Get the list of foreign keys for the current table
• functionList() — Return sql to list functions
• indexList() — Get the list of indexes for the current table
• procedureList() — Return sql to list stored procedures
• random() — Random ordering keyword
• sequenceList() — Return sql to list sequences
• systemTableList() — List the system tables
• tableList() — Returns sql to list tables
• triggerList() — Returns sql to list triggers
• typeList() — SQL to show list of field types
• viewList() — Returns sql to list views

Inherited from Query\Drivers\AbstractSQL

public

• limit() — Limit clause