ExternalTableOptionKind Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:
Microsoft.SqlServer.TransactSql.ScriptDom.dll
Package:
Microsoft.SqlServer.DacFx.x64 v140.3881.1
Package:
Microsoft.SqlServer.DacFx v150.5282.3
Package:
Microsoft.SqlServer.DacFx v160.6161.0
Package:
Microsoft.Data.Tools.Msbuild v10.0.61804.210
Package:
Microsoft.SqlServer.TransactSql.ScriptDom v161.8901.0

The external table options.

public enum ExternalTableOptionKind
type ExternalTableOptionKind = 
Public Enum ExternalTableOptionKind
Inheritance
Enum
ExternalTableOptionKind

Fields

Name Value Description
Distribution 0

The distribution policy of the external data.
FileFormat 1

The file format the external table is affiliated with.
Location 2

The location (file name or path) of the external data.
RejectSampleValue 3

Number of rows to retrieve before recalculating the reject percentage.
RejectType 4

Reject policy to use when accessing external data.
RejectValue 5

Value or percentage of rows that can be rejected before the query fails.
SchemaName 6

The schema of the remote object the external table is acting as a proxy for.
ObjectName 7

The name of the remote object the external table is acting as a proxy for.
RejectedRowLocation 8

The directory within the External Data Source where rejected rows and the corresponding error file are written.
TableOptions 9

Specifies the set of options that describe how to read the underlying files.

Applies to