usql.databases (U-SQL)
Updated: September 26, 2017
Contains one row per database belonging to the account's catalog.
| Column name | Data type | Description |
|---|---|---|
| database_id_guid | Guid | Database's unique identifier (unique within an account) |
| name | string | Database name (unique within an account) |
| create_date | DateTime? | Date and time when the database was created (in UTC-0 time zone). Value may be null for databases that were created before the system started to track this information. |
Examples
The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.
Query the usql.databases view
OUTPUT usql.databases TO "/ReferenceGuide/CatalogViews/databases.txt" USING Outputters.Tsv(outputHeader:true);
See Also
Community Additions
ADD
Show: