windows,linux,cpanel,sql server,classic asp,php,wordpress,facebook,magento,jquery,css,javascript SQL Server Change Default Schema for User » Technology Blog

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