Documentation

SQL extends AbstractSQL
in package

SQLite Specific SQL

Table of Contents

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

Methods

columnList()

SQL to show information about columns in a table

public columnList(string $table) : string
Parameters
$table : string
Return values
string —

dbList()

Returns sql to list other databases. Meaningless for SQLite, as this just returns the database(s) that we are currently connected to.

public dbList() : string
Return values
string —

explain()

Get the query plan for the sql query

public explain(string $sql) : string
Parameters
$sql : string
Return values
string —

fkList()

Get the list of foreign keys for the current table

public fkList(string $table) : string
Parameters
$table : string
Return values
string —

functionList()

Return sql to list functions

public functionList() : string
Tags
throws
NotImplementedException
Return values
string —

indexList()

Get the list of indexes for the current table

public indexList(string $table) : string
Parameters
$table : string
Return values
string —

limit()

Limit clause

public limit(string $sql, int $limit[, int|null $offset = NULL ]) : string
Parameters
$sql : string
$limit : int
$offset : int|null = NULL
Return values
string —

procedureList()

Return sql to list stored procedures

public procedureList() : string
Tags
throws
NotImplementedException
Return values
string —

random()

Random ordering keyword

public random() : string
Return values
string —

sequenceList()

Return sql to list sequences

public sequenceList() : string
Return values
string —

systemTableList()

List the system tables

public systemTableList() : array<string|int, string>
Return values
array<string|int, string> —

tableList()

Returns sql to list tables

public tableList() : string
Return values
string —

triggerList()

Returns sql to list triggers

public triggerList() : string
Return values
string —

typeList()

SQL to show list of field types

public typeList() : array<string|int, string>
Return values
array<string|int, string> —

viewList()

Returns sql to list views

public viewList() : string
Return values
string — 

        

        
    




    

    

                

    

        

            
Search results