When you click on "Database Diagrams" in SSMS, it will ask to enable diagramming support, which means that a number of objects will be added to the db.
Is there a list of all those objects added to the db?
views:
23answers:
2
+2
A:
Off the top of my head I don't know but to find out you could setup a SQL Server Profiler trace to record and inspect the activity that occurs when you install support for Database Diagrams.
John Sansom
2010-08-10 13:05:31
I got an db update proc, that should preserve, eg skip, diagramming support tables. I need it for 2k5-2k8R2, and it looks like the list is "fluid". If there is no official list, I'll have to do what you suggest.
dmajkic
2010-08-10 16:33:26
A:
According to this Books Online article:
- sysdiagrams table
- sp_alterdiagram stored procedure
- sp_creatediagram stored procedure
- sp_dropdiagram stored procedure
- sp_renamediagram stored procedure
- fn_diagramobjects function
- sp_helpdiagrams stored procedure
- sp_helpdiagramsdefinition stored procedure
- sp_upgraddiagrams stored procedure
Joe Stefanelli
2010-08-10 13:39:23
I just checked against a DB where I have the diagrams installed and I don't see anything like that.
Joe Stefanelli
2010-08-10 16:38:04