|
|
|
Forum Newbie
Group: Forum Members
Last Login: 5/7/2008 9:58:04 AM
Posts: 1,
Visits: 3
|
|
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?
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 6/25/2008 7:26:06 AM
Posts: 474,
Visits: 202
|
|
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
|
|
|
|