Quote Table Name
Add special quotes around table name.
tableQuote(sqtable)
sqtable
: table name, with or without schema name.String with special quotes.
The sqlQuery
function requires special quotes if the table name has spaces. Furthermore, the schema name must not be inside the special quotes.
tableQuote("table") tableQuote("table name") tableQuote("schema.table") tableQuote("schema.table name")
sqlQuery
requires special quotes if the table name has spaces.
Quotes
in base R.
MSSQL-package
gives an overview of the package.