Schema
This section provides a complete list of the Schema properties you can configure in the connection string for this provider.
Property | Description |
Location | A path to the directory that contains the schema files defining tables, views, and stored procedures. |
BrowsableSchemas | This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC. |
Tables | This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC. |
Views | Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC. |
MetadataFilesLocation | The location of the metadata files. Set this to the path of the folder where your metadata files are stored, or the specific path of your file. |
TypeDetectionScheme | Determines how to determine the data types of columns. |
RowScanDepth | The maximum number of rows to scan to look for the columns available in a table. |
PrimaryKeyIdentifier | Set this property to control the name of the primary key. |