How can I get all CREATE VIEW statements in Teradata? How to get all CREATE VIEW statements with a single query?
This Query is used to get the definition of a single view:
show view db.tablename;
You'll need to use the catalog views (h/t to Dieter for alerting me to truncation of RequestText in TablesV):
SELECT
  Tbl.DatabaseName
 ,Tbl.TableName
 ,COALESCE(TblText.LineNo,1) AS LineNo
 ,COALESCE(TblText.RequestText,Tbl.RequestText) AS RequestText
FROM
  DBC.TablesV Tbl
LEFT JOIN
  DBC.TableTextV TblText
    ON TblText.DatabaseName = Tbl.DatabaseName
            AND TblText.TableName = Tbl.TableName
        AND TblText.TableKind = Tbl.TableKind
WHERE
  DatabaseName = &lt;Database name&gt;
    AND TableKind = 'V'