DROP DATA SOURCE (U-SQL)
Updated: March 10, 2017
A data source can be dropped with the DROP DATA SOURCE statement.
This operation cannot be undone! |
| Syntax |
|---|
Drop_Datasource_Statement :=
'DROP' 'DATA' 'SOURCE' ['IF' 'EXISTS'] Datasource_Name.
|
Semantics of Syntax Elements
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 EXISTSis 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.
Example
USE TestReferenceDB; DROP DATA SOURCE IF EXISTS MyAzureSQLDBDataSource; DROP DATA SOURCE IF EXISTS MyAzureSQLDWDataSource; DROP DATA SOURCE IF EXISTS MySQLServerDataSource;
See Also
Community Additions
ADD
Show: