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

ALTER DATA SOURCE (U-SQL)

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

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.

Examples

USE DATABASE TestReferenceDB;

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

See Also

© 2018 Microsoft