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
Thanks.