U-SQL Database Schemas
Summary
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 Statements
Syntax
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;