Unable to create EXTERNAL TABLES on Azure SQL Databse

Question

Can't you create an external table in an Azure SQL database with a format file? I am trying to create an external table for a table that I dumped in the memory store.

On this page: https://msdn.microsoft.com/en-us/library/dn935021.aspx

-- Create a new external table  
CREATE EXTERNAL TABLE [ database_name . [ schema_name ] . | schema_name. ] table_name   
    ( <column_definition> [ ,...n ] )  
    WITH (   
        LOCATION = 'folder_or_filepath',  
        DATA_SOURCE = external_data_source_name,  
        FILE_FORMAT = external_file_format_name  
        [ , <reject_options> [ ,...n ] ]  
    )  
[;]  

Is the documentation wrong or am I missing something? I cannot create a FORMAT FILE file and keep getting

"Invalid syntax next to" EXTERNAL. " error.

CREATE EXTERNAL FILE FORMAT [DelimitedText] 
WITH (
    FORMAT_TYPE = DELIMITEDTEXT, 
    FORMAT_OPTIONS (
        FIELD_TERMINATOR = N'~¶~', 
        USE_TYPE_DEFAULT = False
    ), 
    DATA_COMPRESSION = N'org.apache.hadoop.io.compress.GzipCodec')
GO

Answer 1

() , PolyBase Azure SQL, PolyBase SQL Service 2016 . , Azure SQL Datawarehouse: PolyBase

Azure SQL Azure SQL Datawarehouse, PolyBase, .

:

CREATE EXTERNAL FILE FORMAT TextFormat 
WITH (
    FORMAT_TYPE = DELIMITEDTEXT, 
    FORMAT_OPTIONS (
        FIELD_TERMINATOR = N'~¶~', 
        USE_TYPE_DEFAULT = False
    ), 
    DATA_COMPRESSION = N'org.apache.hadoop.io.compress.GzipCodec')
GO  

Azure SQL Database :

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'EXTERNAL'.

Azure SQL Data​​strong >

Command(s) completed successfully.

Hadoop Azure SQL, Azure blob.