How do I select from a table within a specific schema?

Question

MathWorks Support Team 2020-9-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/732863-how-do-i-select-from-a-table-within-a-specific-schema

回答： MathWorks Support Team 2021-2-1

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?

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

Answer 1

MathWorks Support Team 2020-9-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/732863-how-do-i-select-from-a-table-within-a-specific-schema#answer_611708

在 MATLAB Online 中打开

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:

https://docs.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/transact-sql-syntax-conventions-transact-sql?view=sql-server-ver15