U-SQL Database Schemas
Updated: April 4, 2017
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;
See Also
Community Additions
ADD
Show: