How to Find the Version Information in Teradata.  

Simple run the following command. 

SELECT * FROM dbc.dbcinfo

You result set would look something like below.

InfoKey InfoData

VERSION            06.01.01.56

RELEASE           V2R.06.01.01.49

How to View Column Information in Teradata.

Like the “DESCRIBE” command in Oracle, there are a couple of ways to get the equivalent command/result in Teradata, which gives just column names available in table/view. The following command in Teradata is the equivalent desc command in Oracle.

HELP COLUMN dbname.viewname.*

HELP COLUMN dbname.tablename.*

To see all the columns in a table,

HELP TABLE <table name>

If you are wondering on how to see/show the table definitions in teradata, the following command helps to  to find out the definitions of a particular database object like table or view. 

SHOW TABLE <table name>

OR

SHOW SELECT * FROM dbname.tablename