Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Adding table discovery for ODBC tables would make it possible to access them without having to know the exact layout of the table. This makes it easier to connect to data sources when you either don't know the table layout but you know what you want or the task of mapping the types is either complex or laborious.
ODBC has catalog functions that readily expose this information: SQLColumns for columns, SQLStatistics for indexes, SQLPrimaryKeys for primary keys. Using these it should be possible to expose an adequate mapping of the stored types without having to implement database-specific SQL queries.
Attachments
Issue Links
- relates to
-
MDEV-33484 Expose ODBC catalog functions
-
- Open
-