How to get MS SQL table names via DB tbx

8 ビュー (過去 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