How can you set the default schema for the table in Microsoft SQL Server?
For example, I would like to use the query
SELECT * from Table1
instead of
SELECT * from Schema1.Table1
Shathana. S.R. Answered question April 21, 2023
<code><span class="hljs-keyword">SELECT</span> <span class="hljs-operator">*</span> <span class="hljs-keyword">FROM</span> [myschema].users </code>
But this does not:
<code><span class="hljs-keyword">SELECT</span> <span class="hljs-operator">*</span> <span class="hljs-keyword">FROM</span> users</code> The default schema in SQL Server is a user specific functionality.
Shathana. S.R. Answered question April 21, 2023