database.columns

Get database table column names

Syntax

P = columns(conn)
P = columns(conn,C)
P = columns(conn,C,S)
P = columns(conn,C,S,T)

Description

P = columns(conn) returns all columns for all tables given the database connection conn.

P = columns(conn,C) returns all columns for all tables of all schemas for the given catalog C.

P = columns(conn,C,S) returns the columns for all tables for the given catalog C and schema S.

P = columns(conn,C,S,T) returns the columns for the given database connection conn, the catalog C, the schema S, and the table T.

Was this topic helpful?