Share via

U-SQL Database Schemas

  • Article

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;

See Also