describe equivalent

Database
Enthusiast

describe equivalent

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
2 REPLIES
Enthusiast

Re: describe equivalent

You can use "help column":

HELP COLUMN databasename.viewname.*;

Thanks,
Barry

Enthusiast

Re: describe equivalent

These will describe the columns :

HELP TABLE <>;
HELP VIEW <>;