CREATE SCHEMA (U-SQL)
This statement creates a new schema with the specified name in the current database context.
Create_Schema_Statement := 'CREATE' 'SCHEMA' ['IF' 'NOT' 'EXISTS'] Schema_Name.
Schema_Name := Quoted_or_Unquoted_Identifier.
Specifies the name of the schema in form of a quoted or unquoted U-SQL identifier. If a schema of the given name already exists inside the current database context or the user has no permissions to create a schema, an error is raised.
IF NOT EXISTS
If the optional
IF NOT EXISTSis specified, then the statement creates the schema if it does not already exist, or succeeds without changes if the schema already exists and the user has permission to at least enumerate all existing schemas.
- The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.
- The scripts can be executed locally. An Azure subscription and Azure Data Lake Analytics account is not needed when executed locally.
The following script shows how a user creates a schema called
My Schema. Note that because of the space in the name, the identifier has to be quoted:
CREATE SCHEMA [My Schema];
If the user wants to create a schema in another database than the current database context, then the database context has to be changed explicitly. In the following example, a new database
TestReferenceDB gets created that contains a new schema called
NewSchema in addition to the automatically created
CREATE DATABASE TestReferenceDB; USE DATABASE TestReferenceDB; CREATE SCHEMA NewSchema;