Setting the default schema does not take effect Follow

When I write SQL, do I have to write dbo schema?

Cmdegr,

Your default schema is `guest` (as it shown in database explorer).

Default schema is user specific for SQL Server, so you can change it:

USE <db>;
ALTER USER <user> WITH DEFAULT_SCHEMA = <schema>;