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
Our Random Articles
- Somdev Devvarman ousts Xavier Malisse 6-1, 3-6,7-6(5)
- How To Choose A Good Online Traffic School
- New Year Wishes 2010
- New Year Wishes
- How to use EXTRACT function with date and time columns
More Links
4 Comments
Material that you are providing is very easy to learn. But it is much better than this , if you ll give the full material of this at ONE LINK.
Thank you
Suresh.
That is right Suresh. This is the reason I have given all the links in one page, please visit this
http://readvitamin.com/teradata/
Hope this helps.
Hi. Can anyone tell me how to extract time from timestamp?
For Example
timestamp=’2008-03-28 14:11:04′
i want time ’14:11:04′ from timestamp through query.
Thanks in advance.
Hi Vaideesh,
If you need only time, you can probably try the following;
SELECT time;
To answer your question you should do something like this.
SELECT CAST(VaideeshTime as time(0)) from timestamp;
VaideeshTime
——–
14:11:04
Hope that helps.