ALTER DATA SOURCE (U-SQL)

 

Updated: March 10, 2017

The ALTER DATA SOURCE statement allows to change an existing data source.

Syntax
Alter_Datasource_Statement :=                                                                            
    'ALTER' 'DATA' 'SOURCE' Datasource_Name   
    'SET' Datasource_Options.

Datasource_Name := Quoted_or_Unquoted_Identifier.
Datasource_Options := Datasource_Option {',' Datasource_Option}.

Semantics of Syntax Elements

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

  • Datasource_Options
    Specifies the options that are being changed. The options provide the information on how to connect and interact with the external data source. These options are source specific (although at the moment they all apply to the three supported sources). See CREATE DATA SOURCE (U-SQL) for a list of supported data source options and their semantics.

Example

USE DATABASE TestReferenceDB;

ALTER DATA SOURCE MySQLServerDataSource
SET
    PROVIDER_STRING = "Database=Sales";

See Also

Community Additions

ADD
Show: