DROP DATA SOURCE (U-SQL)
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 optionalIF 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
- The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.
USE TestReferenceDB;
DROP DATA SOURCE IF EXISTS MyAzureSQLDBDataSource;
DROP DATA SOURCE IF EXISTS MyAzureSQLDWDataSource;
DROP DATA SOURCE IF EXISTS MySQLServerDataSource;