database user schema

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.