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
0 个评论
回答(1 个)
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.
0 个评论
此问题已关闭。
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!