SQLTeam.com | Weblogs | Forums

Why is Schema for Database Diagram not dbo?


I have a login named test which has the db_owner role. If that login creates a database diagram named Diagram1, the name of the diagram is test.Diagram1.
But if test creates a table name Table1, the name of the table will be dbo.Table1, it inherits the dbo schema.

Why are database diagrams getting a different schema owner? This is MSSQL 2014



for your user id in the database, what is defined as your default schema?


Thanks for your reply. The default schema for the user is dbo.