Example: Using TableTextV - Teradata Vantage

The following SELECT statement displays information about tables, views, and macros in the Personnel database, assuming that text for the database object is more than 12500 characters.

SELECT TableName,TableKind, LineNo, RequestText( char(50)) FROM
DBC.TableTextV WHERE DatabaseName = 'Personnel'  ORDER BY TableName, LineNo;