key_inspector_all_cols {rquery} | R Documentation |
Return all columns as guess of preferred primary keys.
Description
Return all columns as guess of preferred primary keys.
Usage
key_inspector_all_cols(db, tablename)
Arguments
db |
database handle |
tablename |
character, name of table |
Value
map of keys to keys
See Also
describe_tables
Examples
if (requireNamespace("DBI", quietly = TRUE) && requireNamespace("RSQLite", quietly = TRUE)) {
my_db <- DBI::dbConnect(RSQLite::SQLite(), ":memory:")
DBI::dbWriteTable(my_db,
"d",
data.frame(x=1:3, y=NA))
print(key_inspector_all_cols(my_db, "d"))
DBI::dbDisconnect(my_db)
}
[Package rquery version 1.4.99 Index]