U-SQL Database Schemas
Similar to other database systems and ANSI SQL, U-SQL uses the concept of a schema to group related objects together in the context of a database.
U-SQL provides a built-in schema within each database called dbo that is used as the default schema context. Additionally, U-SQL provides the ability to create and delete additional schemas with schema DDL statements.
Schema_DDL_Statement := Create_Schema_Statement | Drop_Schema_Statement.
A list of schema can be retrieved using the Windows PowerShell cmdlet Get-AzureRmDataLakeAnalyticsCatalogItem. Example command for retrieving schema from the TestReferenceDB
database.
Login-AzureRmAccount;
$DataLakeAnalyticsAccount = "<adla_account>";
Get-AzureRmDataLakeAnalyticsCatalogItem -Account $DataLakeAnalyticsAccount -Path "TestReferenceDB" -ItemType "Schema";
(Get-AzureRmDataLakeAnalyticsCatalogItem -Account $DataLakeAnalyticsAccount -Path "TestReferenceDB" -ItemType "Schema").Name;