我需要删除图表支持表,存储的过程,视图等从SQL Servrer使用TSQL脚本。
有这样的脚本吗?
SQL 2005和2008。
发布于 2011-05-27 08:40:00
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;
这样就把它们都移走了。如果有像add这样的删除图表引用向导,那就更好了。
发布于 2021-08-08 11:37:49
DELETE FROM sysdiagrams -- remove all diagram
DELETE FROM sysdiagrams WHERE name = 'yourDiagram' -- remove with condition
https://stackoverflow.com/questions/525610
复制相似问题