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

Published by

abhilash

a gadget and internet addict , a red hat certified linux administrator with skills in dataware development and online technologies., follow me on twitter @abhilashsnair