R/dbListTables_MariaDBConnection.R

Defines functions dbListTables_MariaDBConnection

Documented in dbListTables_MariaDBConnection

#' @rdname mariadb-tables
#' @usage NULL
dbListTables_MariaDBConnection <- function(conn, ...) {
  # DATABASE(): https://stackoverflow.com/a/8096574/946850
  dbGetQuery(
    conn,
    paste0(
      "SELECT table_name FROM INFORMATION_SCHEMA.tables\n",
      "WHERE table_schema = DATABASE()"
    )
  )[[1]]
}

#' @rdname mariadb-tables
#' @export
setMethod("dbListTables", "MariaDBConnection", dbListTables_MariaDBConnection)

Try the RMariaDB package in your browser

Any scripts or data that you put into this service are public.

RMariaDB documentation built on May 29, 2024, 2:08 a.m.