find_relevant_tables {acdcquery}

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)

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

Value

A character vector containing the names of the relevant tables.