A TableDefinition lets you modify the components of a database table.
final class TableAlterationYou don’t create instances of this class. Instead, you use the Database alter(table:body:) method:
try db.alter(table: "player") { t in // t is TableAlteration
t.add(column: "bonus", .integer)
}Related SQLite documentation: https://www.sqlite.org/lang_altertable.html
import GRDBA toolkit for SQLite databases, with a focus on application development
func alter(table name: String, body: (TableAlteration) -> Void) throws Modifies a database table.
func create(table name: String, options: TableOptions = [], body: (TableDefinition) throws -> Void) throws Creates a database table.
func create(virtualTable name: String, options: VirtualTableOptions = [], using module: String) throws Creates a virtual database table.
func create<Module>(virtualTable tableName: String, options: VirtualTableOptions = [], using module: Module, _ body: ((Module.TableDefinition) throws -> Void)? = nil) throws where Module : VirtualTableModule Creates a virtual database table.
func drop(table name: String) throws Deletes a database table.
func dropFTS4SynchronizationTriggers(forTable tableName: String) throws Deletes the synchronization triggers for a synchronized FTS4 table.
func dropFTS5SynchronizationTriggers(forTable tableName: String) throws Deletes the synchronization triggers for a synchronized FTS5 table.
func rename(table name: String, to newName: String) throws Renames a database table.
struct ColumnTypeAn SQL column type.
enum ConflictResolutionAn SQLite conflict resolution.
enum ForeignKeyActionA foreign key action.
final class TableDefinitionA TableDefinition lets you define the components of a database table.
struct TableOptionsTable creation options.
protocol VirtualTableModuleThe protocol for SQLite virtual table modules.
struct VirtualTableOptionsVirtual table creation options.
@discardableResult func add(column name: String, _ type: Database.ColumnType? = nil) -> ColumnDefinition Appends a column.
func addColumn(literal: SQL) Appends a column.
func addColumn(sql: String) Appends a column.
func drop(column name: String) Drops a column.
func rename(column name: String, to newName: String) Renames a column.