Table of contents
TOC
Collapse the table of content
Expand the table of content

usql.views (U-SQL)

Michael Rys|Last Updated: 5/15/2018
|
4 Contributors

Returns a row for each view belonging to the schemas in the current database context. The schema inherits the columns from the usql.objects view and adds the view specific properties to it.

Column nameData typeDescription
<inherited columns>For a list of columns that this view inherits, see usql.objects.
is_schema_inferredboolIndicates if the schema is inferred from the schema's query expression or has been explicitly provided
definitionstringView's definition (if available)

Examples

The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.

Query the usql.views view

USE TestReferenceDB;

OUTPUT usql.views
TO "/ReferenceGuide/CatalogViews/views.txt"
USING Outputters.Tsv(outputHeader:true);

Query usql.views for multiple databases

@views =
    SELECT "TestReferenceDB" AS db, * FROM TestReferenceDB.usql.views
    UNION ALL
    SELECT "master" AS db, * FROM master.usql.views;

OUTPUT @views
TO "/ReferenceGuide/CatalogViews/views_multiple.txt"
ORDER BY db
USING Outputters.Tsv(outputHeader:true);

See Also

© 2018 Microsoft