sqlCreateTableAs function

Compose query to create a simple table using a statement

sqlCreateTableAs(con, name, sql, with = NULL, ...)

Arguments

• con: A database connection.

• name: The table name, passed on to DBI::dbQuoteIdentifier(). Options are:

  • a character string with the unquoted DBMS table name, e.g. "table_name",
  • a call to DBI::Id() with components to the fully qualified table name, e.g. Id(schema = "my_schema", table = "table_name")
  • a call to DBI::SQL() with the quoted and fully qualified table name given verbatim, e.g. SQL('"my_schema"."table_name"')

• sql: a character string containing SQL statement.

• with: An optional WITH clause for the CREATE TABLE statement.

• ...: Other arguments used by individual methods.