User`s guide

7 Functions — Alphabetical List
7-20
columns
Return database table column names
Syntax
columnlist = columns(conn,catalog)
columnlist = columns(conn,catalog,schema)
columnlist = columns(conn,catalog,schema,tablename)
columnlist = columns(dbmeta,catalog)
columnlist = columns(dbmeta,catalog,schema)
columnlist = columns(dbmeta,catalog,schema,tablename)
Description
columnlist = columns(conn,catalog) returns a list of all column names in the
catalog catalog for the database with the database connection conn.
columnlist = columns(conn,catalog,schema) returns a list of all column names
in the schema schema.
columnlist = columns(conn,catalog,schema,tablename) returns a list of all
column names for the table tablename.
columnlist = columns(dbmeta,catalog) returns a list of all column names in the
catalog catalog for the database whose database metadata object is dbmeta.
columnlist = columns(dbmeta,catalog,schema) returns a list of all column
names in the schema schema.
columnlist = columns(dbmeta,catalog,schema,tablename) returns a list of all
column names for the table tablename.