Info

이 질문은 마감되었습니다. 편집하거나 답변을 올리려면 질문을 다시 여십시오.

Implementing metaobject retrieval with Native ODBC Connection

조회 수: 1(최근 30일)
Alex
Alex 2014년 8월 21일
마감: MATLAB Answer Bot 2021년 8월 20일
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