API for dbi.table
Database Queries Using 'data.table' Syntax

Global functions
.onLoad Source code
[.dbi.table Man page
add_special Source code
as.data.frame Man page
as.data.frame.dbi.table Man page Source code
as.dbi.table Man page Source code
as_cte Source code
as_data_table Source code
assign_and_lock Source code
call_can_aggregate Source code
calls_can_aggregate Source code
can_join_as_x Source code
can_join_as_y Source code
chinook.duckdb Man page Source code
chinook.sqlite Man page Source code
copy_vector Source code
csql Man page Source code
dbAppendTable,dbi.catalog-method Man page
dbAppendTable,dbi.schema-method Man page
dbAppendTable,dbi.table-method Man page
dbAppendTable_dbi_table_pkg Source code
dbCreateTable,dbi.catalog-method Man page
dbCreateTable,dbi.schema-method Man page
dbCreateTable,dbi.table-method Man page
dbCreateTable_dbi_table_pkg Source code
dbExecute,dbi.catalog,ANY-method Man page
dbExecute,dbi.catalog-method Man page
dbExecute,dbi.schema,ANY-method Man page
dbExecute,dbi.schema-method Man page
dbExecute,dbi.table,ANY-method Man page
dbExecute,dbi.table-method Man page
dbExecute_dbi_table_pkg Source code
dbGetInfo,dbi.catalog-method Man page
dbGetInfo,dbi.schema-method Man page
dbGetInfo,dbi.table-method Man page
dbGetInfo_dbi_table_pkg Source code
dbGetQuery,dbi.catalog,ANY-method Man page
dbGetQuery,dbi.catalog-method Man page
dbGetQuery,dbi.schema,ANY-method Man page
dbGetQuery,dbi.schema-method Man page
dbGetQuery,dbi.table,ANY-method Man page
dbGetQuery,dbi.table,missing-method Man page
dbGetQuery,dbi.table-method Man page
dbGetQuery_dbi_table Source code
dbGetQuery_dbi_table_pkg Source code
dbListFields,dbi.catalog,ANY-method Man page
dbListFields,dbi.catalog-method Man page
dbListFields,dbi.schema,ANY-method Man page
dbListFields,dbi.schema-method Man page
dbListFields,dbi.table,ANY-method Man page
dbListFields,dbi.table-method Man page
dbListFields_dbi_table_pkg Source code
dbListObjects,dbi.catalog-method Man page
dbListObjects,dbi.schema-method Man page
dbListObjects,dbi.table-method Man page
dbListObjects_dbi_table_pkg Source code
dbQuoteIdentifier,dbi.catalog,ANY-method Man page
dbQuoteIdentifier,dbi.catalog-method Man page
dbQuoteIdentifier,dbi.schema,ANY-method Man page
dbQuoteIdentifier,dbi.schema-method Man page
dbQuoteIdentifier,dbi.table,ANY-method Man page
dbQuoteIdentifier,dbi.table-method Man page
dbQuoteIdentifier_dbi_table_pkg Source code
dbQuoteLiteral,dbi.catalog-method Man page
dbQuoteLiteral,dbi.schema-method Man page
dbQuoteLiteral,dbi.table-method Man page
dbQuoteLiteral_dbi_table_pkg Source code
dbQuoteString,dbi.catalog,ANY-method Man page
dbQuoteString,dbi.catalog-method Man page
dbQuoteString,dbi.schema,ANY-method Man page
dbQuoteString,dbi.schema-method Man page
dbQuoteString,dbi.table,ANY-method Man page
dbQuoteString,dbi.table-method Man page
dbQuoteString_dbi_table_pkg Source code
dbReadTable,dbi.catalog,ANY-method Man page
dbReadTable,dbi.catalog-method Man page
dbReadTable,dbi.schema,ANY-method Man page
dbReadTable,dbi.schema-method Man page
dbReadTable,dbi.table,ANY-method Man page
dbReadTable,dbi.table-method Man page
dbReadTable_dbi_table_pkg Source code
dbRemoveTable,dbi.catalog,ANY-method Man page
dbRemoveTable,dbi.catalog-method Man page
dbRemoveTable,dbi.schema,ANY-method Man page
dbRemoveTable,dbi.schema-method Man page
dbRemoveTable,dbi.table,ANY-method Man page
dbRemoveTable,dbi.table-method Man page
dbRemoveTable_dbi_table_pkg Source code
dbSendStatement,dbi.catalog,ANY-method Man page
dbSendStatement,dbi.catalog-method Man page
dbSendStatement,dbi.schema,ANY-method Man page
dbSendStatement,dbi.schema-method Man page
dbSendStatement,dbi.table,ANY-method Man page
dbSendStatement,dbi.table,missing-method Man page
dbSendStatement,dbi.table-method Man page
dbSendStatement_dbi_table Source code
dbSendStatement_dbi_table_pkg Source code
dbWithTransaction,dbi.catalog-method Man page
dbWithTransaction,dbi.schema-method Man page
dbWithTransaction,dbi.table-method Man page
dbWithTransaction_dbi_table_pkg Source code
dbWriteTable,dbi.catalog,ANY-method Man page
dbWriteTable,dbi.catalog-method Man page
dbWriteTable,dbi.schema,ANY-method Man page
dbWriteTable,dbi.schema-method Man page
dbWriteTable,dbi.table,ANY-method Man page
dbWriteTable,dbi.table-method Man page
dbWriteTable_dbi_table_pkg Source code
db_short_name Source code
db_short_name_default Source code
dbi.attach Man page Source code
dbi.catalog Man page Source code
dbi.catalog_disconnect Source code
dbi.table Man page Source code
dbi.table-package Man page
dbi.table.DBI Man page
dbi.table_can_join_x Source code
dbi_connection Source code
dbi_connection_package Source code
dbi_connection_package_default Source code
dbi_table_is_simple Source code
dbi_table_object Source code
dbit_xref Source code
default_schema Source code
default_schema_Microsoft_SQL_Server Source code
default_schema_default Source code
default_schema_duckdb Source code
default_schema_mariadb Source code
default_schema_postgres Source code
dim.dbi.table Source code
display_class Source code
example_databases Man page
extract_on_validator Source code
finalize_temp_dbi_table Source code
find_environment Source code
foreign_keys Source code
foreign_keys_ Source code
foreign_keys_Microsoft_SQL_Server Source code
foreign_keys_default Source code
foreign_keys_duckdb Source code
foreign_keys_mariadb Source code
foreign_keys_postgres Source code
foreign_keys_sqlite Source code
get_catalog Source code
get_connection Source code
get_connection.DBIConnection Source code
get_connection.dbi.catalog Source code
get_connection.dbi.schema Source code
get_connection.dbi.table Source code
get_connection.default Source code
get_ctes Source code
get_data_source Source code
get_distinct Source code
get_fields Source code
get_group_by Source code
get_key Source code
get_order_by Source code
get_stringsAsFactors Source code
get_table_schema_from_id Source code
get_where Source code
handle_by Source code
handle_i_call Source code
handle_i_order Source code
handle_i_where Source code
handle_j Source code
handle_over Source code
handle_the_walrus Source code
handy_andy Source code
if_allowed_mode Source code
if_scalar Source code
in_query_cte Source code
init_connection Source code
init_schema Source code
install_active_dbi_table Source code
is.dbi.table Man page Source code
is_call_to Source code
is_dbi_catalog Source code
is_dbi_schema Source code
is_language Source code
is_list_of Source code
is_pristine Source code
is_scalar_atomic Source code
load_chinook_database Source code
make_xref Source code
merge Man page
merge.dbi.table Man page Source code
merge_i_dbi_table Source code
names_list Source code
new_active_dbi_table Source code
new_dbi_table Source code
new_dbi_table_from_id Source code
new_schema Source code
pad_left Source code
paren Source code
paste_prefix Source code
preprocess_by Source code
preprocess_common Source code
preprocess_j Source code
print.dbi.catalog Source code
print.dbi.schema Source code
print.dbi.table Source code
reference.test Man page Source code
related_tables Source code
relational_merge Source code
schemas_to_include Source code
schemas_to_include_Microsoft_SQL_Server Source code
schemas_to_include_default Source code
schemas_to_include_duckdb Source code
schemas_to_include_mariadb Source code
schemas_to_include_postgres Source code
shouldnt_print Source code
sql.join Man page Source code
sql_join Source code
sql_statement Source code
stry Source code
sub_db_identifier Source code
sub_lang Source code
tables_schema Source code
tables_schema_ Source code
tables_schema_Microsoft_SQL_Server Source code
tables_schema_default Source code
tables_schema_duckdb Source code
tables_schema_mariadb Source code
tables_schema_postgres Source code
tables_schema_sqlite Source code
temp_db_path Source code
temporary_dbi_table Source code
temporary_dbi_table_name Source code
temporary_dbi_table_name_Microsoft_SQL_Server Source code
temporary_dbi_table_name_default Source code
translate_sql_ Source code
unique.dbi.table Source code
unique_table_name Source code
unsupported Source code
update_order_by Source code
use_integer Source code
window_calls Source code
write_ctes Source code
write_from Source code
write_from_default Source code
write_group_by Source code
write_group_by_default Source code
write_limit Source code
write_limit_Microsoft_SQL_Server Source code
write_limit_default Source code
write_order_by Source code
write_order_by_default Source code
write_select Source code
write_select_Microsoft_SQL_Server Source code
write_select_default Source code
write_select_query Source code
write_where Source code
write_where_default Source code
ws Source code
dbi.table documentation built on June 29, 2025, 1:07 a.m.