Steps to change Database User's schema in MSSQL

[kumkumsharma]

You can follow below steps:

• Login to SQL server database.
• Now right click on particular database and select “New Query” option.
• After that run this command:

ALTER USER db_user WITH DEFAULT_SCHEMA = dbo;

Here db_user is your database username.