Class

SQLCreateIndexBuilder

Builds SQLCreateIndex queries.

final class SQLCreateIndexBuilder

Topics

Initializers

init(SQLCreateIndex, on: any SQLDatabase)
Create a new SQLCreateIndexBuilder.

Instance Properties

var createIndex: SQLCreateIndex
SQLCreateIndex query being built.
var database: any SQLDatabase
Connection to execute query on.
var query: any SQLExpression
Query being built.

Instance Methods

func column(_:)
Specify a column to include in the created index.
func on(_:)
Specify a table to operate on.
func unique() -> Self
Adds UNIQUE modifier to the index being created.

Relationships

Conforms To

SQLQueryBuilder

See Also

Query Builders

class SQLAlterEnumBuilder
Builds SQLAlterEnum queries.
class SQLAlterTableBuilder
Builds SQLAlterTable queries.
class SQLConflictUpdateBuilder
A builder for specifying column updates and an optional predicate to be applied to rows that caused unique key conflicts during an INSERT.
class SQLCreateEnumBuilder
Builds SQLCreateEnum queries.
class SQLCreateTableBuilder
Builds SQLCreateTable queries.
class SQLCreateTriggerBuilder
Builds SQLCreateTrigger queries.
class SQLDeleteBuilder
Builds SQLDelete queries.
class SQLDropEnumBuilder
Builds SQLDropEnum queries.
class SQLDropIndexBuilder
Builds SQLDropIndex queries.
class SQLDropTableBuilder
Builds SQLDropTable queries.
class SQLDropTriggerBuilder
Builds SQLDropTrigger queries.
class SQLInsertBuilder
Builds SQLInsert queries.
class SQLPredicateGroupBuilder
Nested SQLPredicateBuilder for building expression groups.
class SQLRawBuilder
Builds raw SQL queries.
class SQLReturningResultBuilder
A builder returned from the methods of SQLReturningBuilder; this builder wraps the original builder with one which provides SQLQueryFetcher conformance. As such, the returning(_:) methods must always be the last ones in any call chain.