Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to remove diagramming support objects from SQL Server?

Tags:

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.

like image 821
dmajkic Avatar asked Feb 08 '09 12:02

dmajkic


2 Answers

DROP PROCEDURE dbo.sp_alterdiagram;  
DROP PROCEDURE dbo.sp_creatediagram;  
DROP PROCEDURE dbo.sp_dropdiagram; 
DROP PROCEDURE dbo.sp_helpdiagramdefinition; 
DROP PROCEDURE dbo.sp_renamediagram; 
DROP PROCEDURE dbo.sp_upgraddiagrams; 
DROP PROCEDURE dbo.sp_helpdiagrams;
DROP FUNCTION dbo.fn_diagramobjects;
DROP TABLE dbo.sysdiagrams;

That removes all of them. Would be nice if there was as remove diagrams references wizard like the add.

like image 105
Jason Short Avatar answered Nov 11 '22 08:11

Jason Short


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 (?)
like image 31
gbn Avatar answered Nov 11 '22 09:11

gbn