Class

SQLAlterTableBuilder

Builds SQLAlterTable queries.

final class SQLAlterTableBuilder

Topics

Initializers

init(SQLAlterTable, on: any SQLDatabase)
Create a new SQLAlterTableBuilder.

Instance Properties

var alterTable: SQLAlterTable
SQLAlterTable query being built.
var columns: [any SQLExpression]
The set of column alteration expressions.
var database: any SQLDatabase
Connection to execute query on.
var query: any SQLExpression
Query being built.

Instance Methods

func addColumn(any SQLExpression) -> Self
Add a new column to the table.
func column(_:type:_:)
Add a new column to the table.
func dropColumn(_:)
Drop an existing column from the table.
func modifyColumn(any SQLExpression) -> Self
Alter an existing column.
func modifyColumn(_:type:_:)
Change an existing column’s type and constraints.
func rename(to:)
Rename the table.
func update(column:type:)
Change an existing column’s type.

Relationships

Conforms To

SQLQueryBuilder

See Also

Query Builders

class SQLAlterEnumBuilder
Builds SQLAlterEnum 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 SQLCreateIndexBuilder
Builds SQLCreateIndex 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.