A composite view is a virtual data table defined by SQL and TDV metadata. A view defines a SQL query that comprises a SELECT statement and any ANSI-standard SQL clauses and functions. A view can JOIN or UNION to any resource defined in the TDV virtual data layer.

A view is designated in the resource tree with the View icon.

For more information about the View UI, see View and Table Editor Panel Reference

Views can be selectively published to make them available through client applications or the Web. If you want to make a view available to client programs, you must publish that view. See Publishing Resources to a Database Service and Publishing Resources to a Web Service for more information.

For information on scheduling a view’s execution, see Creating a Timer Event Trigger.