| title | sys.external_data_sources (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/14/2017 | |
| ms.prod | sql-non-specified | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | 1016db6e-9950-4ae2-a004-bd4171e27359 | |
| caps.latest.revision | 7 | |
| author | JennieHubbard | |
| ms.author | jhubbard | |
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2016-all_md]
Contains a row for each external data source in the current database for [!INCLUDEssNoVersion], [!INCLUDEssSDS], and [!INCLUDEssSDW].
Contains a row for each external data source on the server for [!INCLUDEssPDW].
| Column Name | Data Type | Description | Range |
|---|---|---|---|
| data_source_id | int | Object ID for the external data source. | |
| name | sysname | Name of the external data source. | |
| location | nvarchar(4000) | The connection string, which includes the protocol, IP address, and port for the external data source. | |
| type_desc | nvarchar(255) | Data source type displayed as a string. | HADOOP, RDBMS, SHARD_MAP_MANAGER, RemoteDataArchiveTypeExtDataSource |
| type | tinyint | Data source type displayed as a number. | 0 - HADOOP 1 - RDBMS 2 - SHARD_MAP_MANAGER 3 - RemoteDataArchiveTypeExtDataSource |
| resource_manager_location | nvarchar(4000) | For type HADOOP, the IP and port location of the Hadoop resource manager. This is used for submitting a job on a Hadoop data source. NULL for other types of external data sources. |
|
| credential_id | int | The object ID of the database scoped credential used to connect to the external data source. | |
| database_name | sysname | For type RDBMS, the name of the remote database. For type, SHARD_MAP_MANAGER, the name of the shard map manager database. NULL for other types of external data sources. | |
| shard_map_name | sysname | For type SHARD_MAP_MANAGER, the name of the shard map. NULL for other types of external data sources. |
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.
sys.external_file_formats (Transact-SQL)
sys.external_tables (Transact-SQL)
CREATE EXTERNAL DATA SOURCE (Transact-SQL)