usql.schemas (U-SQL)
Updated: September 26, 2017
Contains a row for each database schema in the current database context.
| Column name | Data type | Description |
|---|---|---|
| schema_id_guid | Guid | Schema's unique identifier (unique within a database) |
| name | string | Schema name (unique within a database) |
| database_id_guid | Guid | Identifier of the database that contains the schema |
Examples
The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.
Query the usql.schemas view
USE TestReferenceDB; OUTPUT usql.schemas TO "/ReferenceGuide/CatalogViews/schemas.txt" USING Outputters.Tsv(outputHeader:true);
Query the usql.schemas view with usql.databases view
@schemas =
SELECT d.name AS dbName,
s.*
FROM usql.schemas AS s
JOIN usql.databases AS d
ON s.database_id_guid == d.database_id_guid;
OUTPUT @schemas
TO "/ReferenceGuide/CatalogViews/schemas_databases.txt"
USING Outputters.Tsv(outputHeader:true);
See Also
Community Additions
ADD
Show: