How to remove diagramming support objects from SQL Server?

Question

I need to remove diagramming support tables, stored procs, views, etc from SQL Servrer using TSQL script.

Is there such a script available?

SQL 2005 and 2008.

Answer 1

You can drop the objects, but a user will be prompted to recreate them when they click the diagrams node.

Objects: sp_upgraddiagrams, sp_helpdiagrams, sp_helpdiagramdefinition, sp_creatediagram, sp_renamediagram,sp_alterdiagram,sp_dropdiagram,fn_diagramobjects, sysdiagrams, dt_properties (?)