How do I select from a table within a specific schema?
显示 更早的评论
I would like to query a table in a database under a specific schema. In Database Explorer, I can select the schema in the Data Browser panel. How do I do this programmatically?
采纳的回答
MathWorks Support Team
2020-9-15
This would depend on which command you are using to query the database:
If you are using 'sqlread', you can specify it as a argument:
tablename = 'productTable';
data = sqlread(conn,tablename,'Schema','dbo');
If you are using 'fetch' or 'select', then in your SQL statement, you specify the schema with the table name:
results = fetch(conn, 'SELECT * FROM schemaName.inventoryTable');
You can find more information regarding the SQL statement syntax in the documentation for your database. For SQL Server, we see this syntax explained here:
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息
2020-9-15
2021-2-1
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
