SHOW command shows incomplete definition

Tools

SHOW command shows incomplete definition

SHOW command has a limitation of displaying not more than 12500 characters.

Is there any way of selecting the complete DDL of a view other than using the SHOW command so that a larger definition may be viewed completely?
1 REPLY
Senior Apprentice

Re: SHOW command shows incomplete definition

Hi,
if you do a "show view foo" it's the full source code (unless you run a very old Teradata version)´.
Only a "SHOW select ..." has limited size, but please, don't ask me why :-)

Dieter