CODEWITHSUNDEEP
teradata
user3013022
user3013022

Reputation: 196

Unable to get full definition of table in teradata

I am trying to get the definition of table in teradata and I am using following command

   show table DatabaseName.TableName;

This works fine for small tables but for large table it's not showing the full definition. Is there any other way for this.

I am running this query on teradata sql assistant version 13.0

please help.

Upvotes: 0

Views: 1424

Answers (1)

dnoeth
dnoeth

Reputation: 60482

Your're running a quite old version of SQL Assistant and probably a quite old version of ODBC, too.

There was a bug truncating the result of a SHOW TABLE, but it was fixed years ago.

Try to get a newer release of ODBC and/or SQL Assistant (or switch to the .NET provider)

http://downloads.teradata.com/download

Upvotes: 1

Related Questions