Share via

ALTER DATA SOURCE (U-SQL)

  • Article

Summary

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

Remarks

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

Examples

USE DATABASE TestReferenceDB;

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

See Also