Share via

ExternalDataSourceType Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Smo
Assembly:
Microsoft.SqlServer.SqlEnum.dll
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

The enumeration specifies the external data source type for external tables

[System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Smo.ExternalDataSourceTypeConverter))]
public enum ExternalDataSourceType
[<System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Smo.ExternalDataSourceTypeConverter))>]
type ExternalDataSourceType = 
Public Enum ExternalDataSourceType
Inheritance
Enum
ExternalDataSourceType
Attributes
TypeConverterAttribute

Fields

Name Value Description
Hadoop 0

Hadoop external data source type; used by Polybase.
Rdbms 1

Rdbms external data source type; used by Global Query (GQ).
ShardMapManager 2

ShardMapManager external data source type; used by Global Query (GQ).
BlobStorage 5

Azure blob storage for use with BULK INSERT or OPENROWSET
ExternalGenerics 6

PolyBase External Generics; used by PolyBase ODBC Generic Connectors. For PolyBase External Generics we remove TYPE from CREATE / ALTER EXTERNAL DATA SOURCE statement entirely.

Applies to