Query specific catalog in MS SQL DB
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Arpan Badeka
am 4 Apr. 2019
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 Kommentare
Siehe auch
Kategorien
Mehr zu Database Toolbox finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!