Table of contents
TOC
Collapse the table of content
Expand the table of content

DROP DATA SOURCE (U-SQL)

Michael Rys|Last Updated: 5/15/2018
|
4 Contributors

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.

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 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

© 2018 Microsoft