SHOW VIEW results split

Teradata Studio
Highlighted
Enthusiast

SHOW VIEW results split

Does anyone know why the restuls from a "SHOW VIEW" would split the results?   The results are usually one row, but I have a two rows displaying. The view is 829 lines, with comments.  Teradata v 15.10.7.30 using Studio Express, SQL Assistant, and Aqua Data Studio v19.

Tags (1)

Accepted Solutions
Teradata Employee

Re: SHOW VIEW results split

SHOW returns the text as VARCHAR not CLOB, so sometimes multiple rows are needed to hold all the text.

Normally SQL Assistant and Studio [Express] will display the results without a split.

1 ACCEPTED SOLUTION
3 REPLIES 3
Teradata Employee

Re: SHOW VIEW results split

SHOW returns the text as VARCHAR not CLOB, so sometimes multiple rows are needed to hold all the text.

Normally SQL Assistant and Studio [Express] will display the results without a split.

Enthusiast

Re: SHOW VIEW results split

Thank you for clarification. I've not seen multiple lines prior to this, but it makes sense.

Teradata Employee

Re: SHOW VIEW results split

There was a time when the SHOW text was simply truncated to whatever fit in one row, but that is no longer the case.