+---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ [?1034hSQL> help cust_info +---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+----------+---------------------------------------------------------------------------------------------------------------------------------+------------+------------+-------+-------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+-----------------+------------------+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+ | TABLE_QUALIFIER | TABLE_OWNER | TABLE_NAME | COLUMN_NAME | DATA_TYPE| TYPE_NAME | PRECISION | LENGTH | SCALE | RADIX | NULLABLE| REMARKS | COLUMN_DEF | SQL_DATA_TYPE| SQL_DATETIME_SUB| CHAR_OCTET_LENGTH| ORDINAL_POSITION| IS_NULLABLE | SS_DATA_TYPE| +---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+----------+---------------------------------------------------------------------------------------------------------------------------------+------------+------------+-------+-------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+-----------------+------------------+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+ | test1 | dbo | cust_info | id | -5 | bigint | 19 | 8 | 0 | 10 | 0 | | | -5 | | | 1 | NO | 63 | | test1 | dbo | cust_info | company | 12 | varchar | 40 | 40 | | | 1 | | | 12 | | 40 | 2 | YES | 39 | | test1 | dbo | cust_info | created_on | 11 | datetime | 23 | 16 | 3 | | 1 | | | 9 | 3 | | 3 | YES | 111 | | test1 | dbo | cust_info | next_bill_date | -9 | date | 10 | 20 | | | 1 | | | -9 | | | 4 | YES | 0 | | test1 | dbo | cust_info | discount | 6 | float | 15 | 8 | | 10 | 1 | | | 6 | | | 5 | YES | 109 | | test1 | dbo | cust_info | sales | 2 | numeric | 6 | 8 | 2 | 10 | 1 | | | 2 | | | 6 | YES | 108 | | test1 | dbo | cust_info | percentage | 2 | numeric | 15 | 17 | 3 | 10 | 1 | | | 2 | | | 7 | YES | 108 | | test1 | dbo | cust_info | my_double | 6 | float | 15 | 8 | | 10 | 1 | | | 6 | | | 8 | YES | 109 | +---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------------+----------+---------------------------------------------------------------------------------------------------------------------------------+------------+------------+-------+-------+---------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------+-----------------+------------------+-----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+ SQLRowCount returns 8 8 rows fetched SQL>