Share via


U-SQL Views

Summary

U-SQL supports creating and dropping views over rowsets.

View DDL Statements

Syntax

View_DDL_Statement :=                                                                                    
     Create_View_Statement
|    Drop_View_Statement.

In U-SQL Views will be inlined into the expression where they are being referenced and thus are similar to the rowset expression variables, which the difference that the variables only exist for the duration of a script while a view will be made available through the metadata catalog to other scripts.

Unlike tables that can be created with a query expressions, views are not copying the data but are always executed against the data over which the view is defined. This avoids copying the data and thus will always pick up the latest data while costing the execution of the query expression in every query.

U-SQL also provides parameterized views through table-valued functions.

See Also