Setting the default schema does not take effect

Answered

Setting the default schema does not take effect

 

I have set the default schema, but the SQL prompt must select the schema.

 

0
2 comments

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

0

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

 

0

Please sign in to leave a comment.