TableAlteration

public final class TableAlteration

The TableAlteration class lets you alter database tables.

You don’t create instances of this class. Instead, you use the Database alter(table:) method:

try db.alter(table: "player") { t in // t is TableAlteration
    t.add(column: ...)
}

Show on GitHub


                    
                    
                    add(column:_:)

Appends a column to the table.

try db.alter(table: "player") { t in
    t.add(column: "url", .text)
}

Swift

@discardableResult
public func add(column name: String, _ type: Database.ColumnType? = nil) -> ColumnDefinition

`name`	the column name.
`type`	the column type.

An ColumnDefinition that allows you to refine the column definition.

Show on GitHub


                    
                    
                    rename(column:to:)

Renames a column in a table.

try db.alter(table: "player") { t in
    t.rename(column: "url", to: "homeURL")
}


                    
                    
                    rename(column:to:)

Renames a column in a table.

try db.alter(table: "player") { t in
    t.rename(column: "url", to: "homeURL")
}

Swift

@available(iOS 13.0, tvOS 13.0, watchOS 6.0, *)
public func rename(column name: String, to newName: String)

`name`	the column name to rename.
`newName`	the new name of the column.

Show on GitHub