Categories
Latest
Popular

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