dot-list_columns: List all columns in a table (S3 generic)

In framework: Structured Data Science Project Scaffolding

List all columns in a table (S3 generic)

Description

Cross-database method to list all columns in a table. Uses database-specific introspection methods via S3 dispatch.

Usage

.list_columns(conn, table_name)

## S3 method for class 'SQLiteConnection'
.list_columns(conn, table_name)

## S3 method for class 'PqConnection'
.list_columns(conn, table_name)

## S3 method for class 'MariaDBConnection'
.list_columns(conn, table_name)

## S3 method for class ''Microsoft SQL Server''
.list_columns(conn, table_name)

## S3 method for class 'duckdb_connection'
.list_columns(conn, table_name)

## Default S3 method:
.list_columns(conn, table_name)

Arguments

conn	Database connection (DBIConnection)
table_name	Character. Name of the table

Value

Character vector of column names

Functions

• .list_columns(SQLiteConnection): SQLite implementation using PRAGMA

• .list_columns(PqConnection): PostgreSQL implementation using information_schema

• .list_columns(MariaDBConnection): MySQL/MariaDB implementation using information_schema

• .list_columns(`Microsoft SQL Server`): SQL Server implementation using information_schema

• .list_columns(duckdb_connection): DuckDB implementation using information_schema

• .list_columns(default): Default implementation using information_schema

Examples

if (FALSE) {
conn <- connection_get("my_db")
columns <- .list_columns(conn, "users")
DBI::dbDisconnect(conn)
}

framework documentation built on Feb. 18, 2026, 1:07 a.m.