User`s guide

7 Functions — Alphabetical List

7-56

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.