Describe table

Database

Describe table

In SAS sql there is a command "describe table" which gives information about the table in question. Is there a similar command in Teradata sql.?
7 REPLIES
N/A

Re: Describe table

HELP TABLE DatabaseName.TableName; is probably the closest thing.
N/A

Re: Describe table

HELP TABLE is only returning column definition, but SHOW TABLE gives the full CREATE TABLE statement.

Dieter

Re: Describe table

Thank you Show Table is just what i was after

Re: Describe table

how to view data types of all coulums
N/A

Re: Describe table

Re: Describe table

Can HELP TABLE or another command be used to extract just all the column-names of a table? Thanks for any help.

Re: Describe table

PS With just normal user-rights on the DB. jb