ADO.NET Provider for CSV

Build 22.0.8462

Schema

This section provides a complete list of the Schema properties you can configure in the connection string for this provider.


PropertyDescription
LocationA path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemasThis property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
TablesThis property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
ViewsRestricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.
SchemaIniLocationA path to the directory that contains the schema.ini file.
AggregateFilesWhen set to true, the provider will aggregate into a single table called AggregatedFiles all the files located in the URI directory which have the same schema.
MetadataDiscoveryURIUsed together with AggregateFiles , this property specifies a specific file to read the schema of the AggregatedFiles result set.
TypeDetectionSchemeDetermines how to determine the data types of columns.
ColumnCountThe number of columns to detect when dynamically determining columns for the table.
RowScanDepthThe number of rows to scan when dynamically determining columns for the table.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462