Press enter to see results or esc to cancel.

SQL Server Change Default Schema for User


 

 

For changing default schema for a database user associated with SQL Login

ALTER USER [user] WITH DEFAULT_SCHEMA= [schema]

Eg.

for changing schema to schema1 for user user1

ALTER USER [user1] WITH DEFAULT_SCHEMA= [schema1]

Remember to maintain square brackets



Comments

Comments are disabled for this post