O'Reilly logo

V14 Certification: Teradata SQL by Tom Coffing, Leona Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 23 – HELP and SHOW

“The whole secret of existence is to have no fear. Never fear what will become of you, depend on no one. Only the moment you reject all help are you freed.

- Buddha

Determining the Release of your Teradata System

SELECT * FROM DBC.DBCINFO;   

InfoKey

InfoData

RELEASE

13.00.00.12

VERSION

13.00.00.12

LANGUAGE SUPPORT MODE

Standard

The above query pulls information from the Data Dictionary in USER DBC. Some companies don’t allow users to see this information, but if you have the access rights then you can run the above query.

Basic HELP Commands

HELP DATABASE <database-name> ; Displays the names of all the tables (T), views (V), macros (M), and triggers (G) stored in a database and user-written table ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required