How to get MS SQL table names via DB tbx

조회 수: 9 (최근 30일)
YUC hu
YUC hu 2011년 8월 26일
Hi I am new in using MS SQL and the DB tbx. Coould anyone tell me how can I get table names in MS SQL using DB tbx? Is there anything similar to MYM for MS SQL? It seems MYM is much user friendly for newbie. Thanks RAY

이 질문에 답변하려면 로그인하십시오.

답변 (2개)

Oleg Komarov
Oleg Komarov 2011년 8월 26일
If you want a user-friendly approach you can use the querybuilder.
Otherwise you can use MS SQL JDBC connection to connect to your database (you can find detailed instruction on that page) and after you can simply use database.fetch to retrieve data.
Quattro
Quattro 2011년 8월 26일
If you already have established a database connection:
T=tables(conn)
See for further help
help database.tables
To connect to a database, see
help database

카테고리

Help Center 및 File Exchange에서 Database Toolbox에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by