How to change the schema for a diagram?

Question

Hi,

Diagrams created with Microsoft SQL Server Management Studio have their default schema set to dbo. It seems that there is no way to set another schema when creating a diagram.

For tables,

alter schema NewSchemaName transfer dbo.TableName

moves a specified table to the new schema. But the same command does not work for diagrams.

Is it possible to change the schema once the diagram created?

Answer 1

No.

Diagrams do not have schemas because they aren't rows/objects in sys.objects.

They have owners but not in the schema/user separation sense.