Rename SQLite Column — rws_rename_column • readwritesqlite

Rename SQLite Column

rws_rename_column(table_name, column_name, new_column_name, conn)

Arguments

table_name: A string of the name of the table.
column_name: A string of the column name.
new_column_name: A string of the new name for the column.
conn: A SQLiteConnection to a database.

Value

TRUE

See also

Other rws_rename: rws_drop_table(), rws_rename_table()

Examples

conn <- rws_connect()
rws_write(data.frame(x = 1), x_name = "local", exists = FALSE, conn = conn)
rws_read_table("local", conn = conn)
#> # A tibble: 1 × 1
#>       x
#>   <dbl>
#> 1     1
rws_rename_column("local", "x", "Y", conn = conn)
#> [1] TRUE
rws_read_table("local", conn = conn)
#> # A tibble: 1 × 1
#>       Y
#>   <dbl>
#> 1     1
rws_disconnect(conn)