Query specific catalog in MS SQL DB

1 次查看（过去 30 天）
Anthony Crockford
Anthony Crockford 2019-1-18
回答： Arpan Badeka 2019-4-4
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.

请先登录，再回答此问题。

回答（1 个）

Arpan Badeka
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');

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by