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

abhilash

abhilash, is a programmer by profession and a technology addict with a passion towards browsing , shopping and imaging . My views may be biased on reviews. all images and videos are copyrighted to respective owners.

Add comment

Your Header Sidebar area is currently empty. Hurry up and add some widgets.