CreateIndexSQL class

A CREATE INDEX SQL builder.

Inheritance

Constructors

CreateIndexSQL(SQLDialect dialect, String table, String column, String? indexName, {String q = '"', bool unique = false})
A single-column index.
CreateIndexSQL.columns(SQLDialect dialect, String table, List<String> columns, String? indexName, {String q = '"', bool unique = false})
An index over columns (in this order), e.g. a composite index (EntityIndex).

Properties

allSQLBuilders → List<SQLBuilder>
All the SQLs of this builder tree node.
no setterinherited
column → String
The (first) column.
final
columns → List<String>
The indexed columns, in order (one for a single-column index).
final
dependentTables → List<String>
Returns a list of dependent tables, usually referenced tables.
no setteroverride
dialect → SQLDialect
The SQL dialect.
finalinherited
extraSQLBuilders → List<SQLBuilder>?
Some extra SQL related to this SQL.
no setteroverride
hashCode → int
The hash code for this object.
no setterinherited
indexName → String?
The name of the index;
final
isComposite → bool
Whether it's an index over more than one column.
no setter
mainTable → String
The main table of the SQL.
no setteroverride
q → String
The quote of the dialect.
finalinherited
referenceTables → List<String>
Returns a list of referenced tables.
no setteroverride
referenceTablesLength → int
Returns a number of referenced tables.
no setterinherited
runtimeType → Type
A representation of the runtime type of the object.
no setterinherited
table → String
The table name.
final
unique → bool
Whether it's a unique index (CREATE UNIQUE INDEX).
final

Methods

buildAllSQLs({bool multiline = true, bool ifNotExists = true}) → List<String>
Build all the SQLs, including the extraSQLBuilders.
inherited
buildSQL({bool multiline = true, bool ifNotExists = true}) → String
Build the SQL.
override
compareTo(SQLBuilder other) → int
Compares this object to another object.
override
noSuchMethod(Invocation invocation) → dynamic
Invoked when a nonexistent method or property is accessed.
inherited
toString() → String
A string representation of this object.
override

Operators

operator ==(Object other) → bool
The equality operator.
inherited