R/getTableColumns.R

Defines functions getTableColumns

Documented in getTableColumns

#' getTableColumns
#'
#' Issues query against the RDBS to retrieve information about each column
#' of the table. Name, type, length, precision, etc.
#'
#' @param conn.info Connection info created with \code{\link{prepareConnection}}
#' @param schema Table schema
#' @param table Table name
#'
#' @return data frame containing the columns' metadata
#' @export
getTableColumns <- function(conn.info, schema, table){

  # opens connection to db
  conn <- connectDB(conn.info)

  # builds query to retrieve columns metadata
  query.columns <- buildQueryColumnMetadata(conn.info,
                                            schema = schema,
                                            table = table)

  # issues the query
  columns.metadata <- odbc::dbGetQuery(conn, query.columns)

  # disconnects
  closeConnection(conn)
  return(columns.metadata)
}

Try the datrProfile package in your browser

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

datrProfile documentation built on Aug. 2, 2019, 5:05 p.m.