SET QUOTED_IDENTIFIER ON

GO
-- Remove the discarded Option B assembly objects (rebuilt on catAssets + IsAssembly).
DROP PROCEDURE IF EXISTS [MMS].[GetAssemblies];
DROP PROCEDURE IF EXISTS [MMS].[UpsertAssembly];
DROP PROCEDURE IF EXISTS [MMS].[DeleteAssembly];
DROP PROCEDURE IF EXISTS [MMS].[GetAssemblyParts];
DROP PROCEDURE IF EXISTS [MMS].[LinkAssemblyParts];
DROP PROCEDURE IF EXISTS [MMS].[UnlinkAssemblyPart];
DROP PROCEDURE IF EXISTS [MMS].[GetAssemblyDrawings];
DROP PROCEDURE IF EXISTS [MMS].[LinkAssemblyDrawings];
DROP PROCEDURE IF EXISTS [MMS].[UnlinkAssemblyDrawing];
GO
DROP TABLE IF EXISTS [MMS].[AssemblyParts];
DROP TABLE IF EXISTS [MMS].[AssemblyDrawings];
DROP TABLE IF EXISTS [MMS].[Assemblies];
GO

