dbQuoteIdentifier
(or possibly dbQuoteString
) instead.
make.db.names(dbObj, snames, keywords = .SQL92Keywords, unique = TRUE, allow.keywords = TRUE, ...)
make.db.names.default(snames, keywords = .SQL92Keywords, unique = TRUE, allow.keywords = TRUE)
isSQLKeyword(dbObj, name, keywords = .SQL92Keywords, case = c("lower", "upper", "any")[3], ...)
isSQLKeyword.default(name, keywords = .SQL92Keywords, case = c("lower", "upper", "any")[3])
DBIDriver
)..SQL92Keywords
defined by the DBI.TRUE
. Following the SQL 92
standard, uniqueness of SQL identifiers is determined regardless of whether
letters are upper or lower case.TRUE
any
.make.db.names
returns a character vector of legal SQL
identifiers corresponding to its snames
argument.SQLKeywords
returns a character vector of all known keywords for the
database-engine associated with dbObj
.isSQLKeyword
returns a logical vector parallel to name
.
make.names
and
then back to SQL with make.db.names
will not be equal to the
original SQL identifiers (e.g., compound SQL identifiers of the form
username.tablename
will loose the dot ``.'').make.db.names
first invokes make.names
and
then replaces each occurrence of a dot ``.'' by an underscore ``\_''. If
allow.keywords
is FALSE
and identifiers collide with SQL
keywords, a small integer is appended to the identifier in the form of
"_n"
.The set of SQL keywords is stored in the character vector
.SQL92Keywords
and reflects the SQL ANSI/ISO standard as documented
in "X/Open SQL and RDA", 1994, ISBN 1-872630-68-8. Users can easily
override or update this vector.
.SQL92Keywords
and reflects the SQL ANSI/ISO standard as documented
in "X/Open SQL and RDA", 1994, ISBN 1-872630-68-8. Users can easily
override or update this vector.