<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.

open SQL Server Management Studio, navigate to Security > Logins, right click on the Windows Group that you want to change and choose Properties

The default schema in SQL Server is a user specific functionality.

You can set the default schema in a SQL Server with the T-SQL as shown below.

USE [DPDatabaseName];
ALTER USER [YourUserName] WITH DEFAULT_SCHEMA = [YourSchemaName];

For example, if your database name is TestDB , user name is “developerpublish” and schema is “website”, your query would look like this

USE TestDB;
ALTER USER developerpublish WITH DEFAULT_SCHEMA = website;

Also note that the value of DEFAULT_SCHEMA is ignored if the user is a member of the sysadmin fixed server role.