Clear Filters
Clear Filters

How to get MS SQL table names via DB tbx

2 views (last 30 days)
YUC hu
YUC hu on 26 Aug 2011
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

Answers (2)

Oleg Komarov
Oleg Komarov on 26 Aug 2011
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 on 26 Aug 2011
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

Community Treasure Hunt

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

Start Hunting!