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