15.10 - WITH query_name - Teradata Database

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.