ODBC and Views

How are people dealing with views in ODBC? The TableSchema method does not return them - only tables.

Do you have to query the database for them and, if so, do you need to know which type of database you’re dealing with? I’m struggling to find any redeeming value of working the Xojo ODBC driver.

Yes.
MySQL:
SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE ‘VIEW’;
PostgreSQL:
SELECT * FROM pg_views WHERE schemaname NOT IN(‘information_schema’, ‘pg_catalog’);
MS SQL:
SELECT SCHEMA_NAME(schema_id) AS schema_name
,name AS view_name
FROM sys.views;

Xojo could of course implement some generic call.

That would be nice. <https://xojo.com/issue/44476>

Any idea how to enumerate a list of queries in a Microsoft Access database?