"Query is Invalid"error

Analytics

"Query is Invalid"error

Hi All,

When i execute following sql query using ODBC (Teradata SQL Assistant), it tells me query is invalid, but i am not sure what is incorrect here. please help.

view table tablename;

Note:

I want to display all the columns of a table.

1 REPLY
Senior Apprentice

Re: "Query is Invalid"error

There's no VIEW command, just HELP or SHOW:

  • HELP TABLE myTable; returns column descriptions
  • SHOW TABLE myTable; returns the table's CREATE statement