[SequelSafe] 특정 DB의 형상 관리 내역을 SQLSafe DB에서 삭제하는 스크립트

USE SQLSafe;
GO
 
DECLARE @nvcDatabaseName nvarchar(128);
 
SET @nvcDatabaseName = N''; -- DB 이름을기입합니다.
 
DELETE dbo.DDLLogs
FROM dbo.DDLLogs DL
  INNER JOIN dbo.Objects O ON DL.objectSN = O.objectSN
WHERE O.databaseName = @nvcDatabaseName;
 
DELETE dbo.PartialDeployments
FROM dbo.PartialDeployments PD
  INNER JOIN dbo.DeploymentScripts DS ON PD.deploymentScriptSN = DS.deploymentScriptSN
WHERE DS.databaseName = @nvcDatabaseName;
 
DELETE dbo.DeploymentScripts WHERE databaseName = @nvcDatabaseName;
 
DELETE dbo.ModuleDependencies
FROM dbo.ModuleDependencies MD
  INNER JOIN dbo.Objects O ON MD.majorObjectSN = O.objectSN OR MD.minorObjectSN = O.objectSN
WHERE O.databaseName = @nvcDatabaseName;
 
DELETE dbo.Objects WHERE databaseName = @nvcDatabaseName;
GO