15.10 - WITH query_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

Name of a non-recursive inner query expression.

For information about naming database objects, see SQL Fundamentals, B035-1141.

You can specify multiple non-recursive inner query expressions for a view.

column_name
Name of a column in the named query definition.
select_expression
A non-recursive SELECT request that retrieves the row data to store in the named query.
You can specify an expression that returns a UDT in a column list only if its transform group has a fromsql routine. Teradata Database automatically converts the expression from its UDT value to the external type via the fromsql routine before returning it to a client application.