Share via


usql.objects (U-SQL)

Summary

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 name Data type Description
object_id_guid Guid Object's unique identifier
name string Object's name (in simple, non-qualified form)
schema_id_guid Guid Identifier of the schema that contains the object
type string Object type:

TF = table-valued function

TT = table type

U = user table

V = view
type_desc string Description of the object type:

TABLE_VALUED_FUNCTION

TABLE_TYPE

USER_TABLE

VIEW
create_date DateTime? Date and time of the object's creation (in UTC-0 time zone)
modify_date DateTime? 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