Learn R Programming

acdcquery (version 1.2.3)

find_relevant_tables: Find relevant tables based on column name

Description

This function finds the relevant database tables that contain a specified column.

Usage

find_relevant_tables(conn, column_name, info = NULL, strict = FALSE)

Value

A character vector containing the names of the relevant tables.

Arguments

conn

The connection object or database connection string.

column_name

The name of the column to search for in the database tables.

info

Optional. The information data frame obtained from get_column_names() function. If not provided, it will be obtained within the function.

strict

Should only one table be returned? Relevant for id variables