Find User’s Default Schema

Need to find the default schema for a user in MS SQL?  Need to confirm all your SQL Server users default schema’s are set correctly?  Easy peasey.  Run the following query and enjoy.

(Not sure why you would care what the default schema is for a user?  Better performance is the answer.  You care because in a case where a schema was not specified in a query, SQL Server will first check for the existence of the object in the user’s default schema.)

select default_schema_name
, type_desc
, name
, create_date
from sys.database_principals
order by default_schema_name
, type_desc
, name

Tags: , , , ,

No comments yet.

Leave a Reply