Implementing metaobject retrieval with Native ODBC Connection

Dear fellows,

Is it possible to implement or code in matlab a function to retrieve metadata (similar to dmd, tables, columns) while using native ODBC database connection? I am currently using SQL 2008 in a 64 bit platform and actually missing that precise functionality.

Thank you very much for all help you might provide Alex

Answer 1

[Michael]

Depends on what you need. You could use the INFORMATION_SCHEMA to get some metadata. For instance, if your database schema is db and you want the column names for table1:

columnNames = fetch(conn,['SELECT COLUMN_NAME FROM db.INFORMATION_SCHEMA.COLUMNS ' ...
                          ' WHERE TABLE_NAME=''table1''']);

If you already make extensive use of the dmd, tables, and columns function you could write your own wrapper functions using the INFORMATION_SCHEMA and a native ODBC database connection.