Package index • RtoSQLServer

Write

write_dataframe_to_db(): Write an R data frame to a SQL Server table

Read

read_table_from_db(): Read a SQL Server table into an R dataframe

Modify

add_column(): Add a Column to an existing database table

delete_table_rows(): Delete rows from an existing database table

drop_column(): Drop a Column from an existing database table

drop_table_from_db(): Drop SQL Server table from database

rename_table(): Rename a table in the database

rename_column(): Rename a column in an existing database table

Metadata

db_table_metadata(): Return metadata about an existing database table

show_schema_tables(): Show all tables (and optionally views) in a schema

Database other

create_sqlserver_connection(): Create a connection to a SQL Server database

execute_sql(): Connect, execute SQL in SQL Server database and then disconnect