Share via

DROP DATA SOURCE (U-SQL)

  • Article

Summary

A data source can be dropped with the DROP DATA SOURCE statement.

Warning

This operation cannot be undone!

Syntax

Drop_Datasource_Statement :=                                                                             
    'DROP' 'DATA' 'SOURCE' ['IF' 'EXISTS'] Datasource_Name.

Datasource_Name := 
    Quoted_or_Unquoted_Identifier.

Remarks

  • Datasource_Name
    Specifies the data source to be dropped in the current static database context. If a data source of the given name does not exist, or the user has no permissions to drop the data source, an error is raised.

  • IF EXISTS
    If the optional IF EXISTS is specified, then the statement drops the data source if it already exists, or succeeds without changes if the data source does not exist or the user has no permission to at least enumerate all existing data sources.

Examples

USE TestReferenceDB;
DROP DATA SOURCE IF EXISTS MyAzureSQLDBDataSource;

DROP DATA SOURCE IF EXISTS MyAzureSQLDWDataSource;

DROP DATA SOURCE IF EXISTS MySQLServerDataSource;

See Also