Info

此问题已关闭。 请重新打开它进行编辑或回答。

Implementing metaobject retrieval with Native ODBC Connection

1 次查看(过去 30 天)
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

回答(1 个)

Michael
Michael 2014-9-30
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.

此问题已关闭。

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by