How to get MS SQL table names via DB tbx

2 次查看(过去 30 天)
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 CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by