2.10 - showColumns - Teradata QueryGrid

Teradata® QueryGrid™ Installation and User Guide

prodname
Teradata QueryGrid
vrm_release
2.10
created_date
September 2019
category
Administration
Configuration
Installation
User Guide
featnum
B035-5991-099K

The show*() methods can be used for schema and metadata discovery queries and are equivalent to HELP FOREIGN SERVER/DATABASE/TABLE queries on the Teradata Database. The showColumns method displays the schema of a target table specified by a fully-qualified name (For example: schema.table or database.schema.table).

scala> s1.showColumns("user1.players")
+--------+--------+-------+
|COL_NAME|COL_TYPE|COMMENT|
+--------+--------+-------+
|number  |int     |       |
|name    |string  |       |
+--------+--------+-------+