|
|
|
Junior Member
 
Group: Forum Members
Last Login: 7/3/2008 3:49:29 AM
Posts: 22,
Visits: 21
|
|
like describe command, is there any command available in Teradata to know the columns stored in a view
for e.g describe(in short desc) user_constraints;
the above one will show all the columns available in that view
in teradata select * from dbc.databases will show databasename, creatorname,ownerename....etc
instead of getting the result i am expecting command or query which gives just column names available in dbc.databases
thanks,
Dixon
dixon
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 6/9/2008 2:55:55 PM
Posts: 185,
Visits: 2
|
|
You can use "help column":
HELP COLUMN databasename.viewname.*;
Thanks,
Barry
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 7/24/2008 8:31:03 AM
Posts: 109,
Visits: 22
|
|
These will describe the columns :
HELP TABLE <>;
HELP VIEW <>;
|
|
|
|