CODEWITHSUNDEEP
sql-server
nikotromus
nikotromus

Reputation: 1054

Is it possible to change the default schema?

Is it possible to change the default schema in a database so that I don't have to change it manually every time? Currently it defaults to 'dbo'. I have a lot of tables to set up and it's annoying to have to change for each table.

Upvotes: 0

Views: 2814

Answers (1)

dbajtr
dbajtr

Reputation: 2044

You can on a user level either in the user mapping of the database in SSMS or with T-SQL:

ALTER USER UserName WITH DEFAULT_SCEHMA = SchemaName

Upvotes: 2

Related Questions