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. |
RefreshViewSchemas | Allows the provider to determine up-to-date view schemas automatically. |
ShowTableDescriptions | Controls whether table descriptions are returned via the platform metadata APIs and sys_tables / sys_views. |
PrimaryKeyIdentifiers | Set this property to define primary keys. |
AllowedTableTypes | Specifies what kinds of tables will be visible. |
FlattenObjects | Determines whether the provider flattens STRUCT fields into top-level columns. |