이 질문은 마감되었습니다. 편집하거나 답변을 올리려면 질문을 다시 여십시오.
Implementing metaobject retrieval with Native ODBC Connection
조회 수: 1(최근 30일)
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
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.