sqlcolumns

Syntax

sqlcolumns [owner_name_pattern.]table_name_pattern

Description

Prints results of an ODBC call to SQLColumns. If the optional argument is omitted then all columns in the data source are reported.

Examples

Command> create table t ( c int, b int);
Command> sqlcolumns T;
< <NULL>, USER, T, C, 3, NUMBER, 38, 39, 0, 10, 1, , <NULL>, 3, <NULL>, <NULL>, 1, YES, 1, <NULL>, 0, 0, 00 >
< <NULL>, USER, T, B, 3, NUMBER, 38, 39, 0, 10, 1, , <NULL>, 3, <NULL>, <NULL>, 2, YES, 1, <NULL>, 0, 0, 00 >
2 rows found.