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

usql.objects (U-SQL)

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

Contains a row for certain schema-scoped objects that are created within a database. Currently usql.objects only includes tables, views, table-valued functions and table types. Other objects such as procedures and packages will be added in the future.

Column nameData typeDescription
object_id_guidGuidObject's unique identifier
namestringObject's name (in simple, non-qualified form)
schema_id_guidGuidIdentifier of the schema that contains the object
typestringObject type:

TF = table-valued function

TT = table type

U = user table

V = view
type_descstringDescription of the object type:

TABLE_VALUED_FUNCTION

TABLE_TYPE

USER_TABLE

VIEW
create_dateDateTime?Date and time of the object's creation (in UTC-0 time zone)
modify_dateDateTime?Date and time of the object's last modification (in UTC-0 time zone)

Examples

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

Query the usql.objects view

USE TestReferenceDB;

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

See Also

© 2018 Microsoft