How can I view all column names from a tera data table

[Jeg123]

Im trying to select 1 row from teradata just to view the column names. The problem is I get the following error:

ERROR: At least one of the columns in this DBMS table has a datatype that is not supported by this engine.

proc sql;
connect to teradata as tera (authdomain="TeradataAuth" tdpid=aprod mode=Teradata);

create table work.test as
select * from connection to tera (
select top 1 *
from tera_table.hello
);

disconnect from tera;
quit;

How can i achieve my purpose?

[LinusH]

Try the DBC tables:

http://teradata.iexpertify.com/2011/09/dbc-tables-or-system-tables-on-teradata.html

[tsap]

To achieve the outcome you requested on my own system, I created a libref for the Teradata database connection and then executed a 'PROC CONTENTS' datastep:

LIBNAME Tera TERADATA AUTHDOMAIN="TeradataAuth" TDPID=APROD MODE=Teradata;

PROC CONTENTS DATA=Tera.Hello; RUN;

This is what I mocked up from the information provided in your post.

Hope this helps.