ExternalTableOptionKind Enum
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
The external table options.
public enum ExternalTableOptionKindtype ExternalTableOptionKind = Public Enum ExternalTableOptionKind- Inheritance
-
ExternalTableOptionKind
| 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. |
| Produkt | Versioner |
|---|---|
| Microsoft.SQLServer.DacFx | 140.3881.1, 150.18208.0, 160.2004021.0, 161.6374.0, 161 |