title: "sys.external_data_sources (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database, sql-data-warehouse, pdw" ms.service: "" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" dev_langs:
- "TSQL" ms.assetid: 1016db6e-9950-4ae2-a004-bd4171e27359 caps.latest.revision: 7 author: "stevestein" ms.author: "sstein" manager: "craigg" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
[!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)