Query specific catalog in MS SQL DB
2 次查看(过去 30 天)
显示 更早的评论
Hi,
I need to query an MS SQL data base but I do not know how to select the specific catalog of interest.
Here is my SQL DB architechture:
xxxx.windows.net
- Databases
+ System Databases
+ Database1
+ Database2
...
The connection is defaulted to master catalog but I need tables in Database1, Database2 ...
I have the database toolbox installed and am running R2018a using ODBC Driver 17 for SQL Server.
Can anyone send a few lines of code to help?
Many thx indeed.
0 个评论
回答(1 个)
Arpan Badeka
2019-4-4
Hi Anthony
Use the following query after connecting to the database to get the list of all the tables:
tableList = sqlread(conn, "tables", 'Catalog', Database1, 'Schema', 'information_schema');
0 个评论
另请参阅
类别
在 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!