36 lines
1004 B
Transact-SQL
36 lines
1004 B
Transact-SQL
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
/*
|
|
Rollback della patch parallela Python.
|
|
|
|
Non ripristina oggetti legacy, perche' la patch parallela non li modifica.
|
|
Rimuove solo gli oggetti dbo.py_* e la tabella di prenotazione Python.
|
|
*/
|
|
|
|
IF OBJECT_ID(N'dbo.py_sp_ControllaPrenotazionePackingListPalletNew', N'P') IS NOT NULL
|
|
DROP PROCEDURE dbo.py_sp_ControllaPrenotazionePackingListPalletNew;
|
|
GO
|
|
|
|
IF OBJECT_ID(N'dbo.py_sp_xExePackingListPalletPrenota', N'P') IS NOT NULL
|
|
DROP PROCEDURE dbo.py_sp_xExePackingListPalletPrenota;
|
|
GO
|
|
|
|
IF OBJECT_ID(N'dbo.py_sp_xExePackingListPallet', N'P') IS NOT NULL
|
|
DROP PROCEDURE dbo.py_sp_xExePackingListPallet;
|
|
GO
|
|
|
|
IF OBJECT_ID(N'dbo.py_ViewPackingListRestante', N'V') IS NOT NULL
|
|
DROP VIEW dbo.py_ViewPackingListRestante;
|
|
GO
|
|
|
|
IF OBJECT_ID(N'dbo.py_XMag_ViewPackingList', N'V') IS NOT NULL
|
|
DROP VIEW dbo.py_XMag_ViewPackingList;
|
|
GO
|
|
|
|
IF OBJECT_ID(N'dbo.PyPickingListReservation', N'U') IS NOT NULL
|
|
DROP TABLE dbo.PyPickingListReservation;
|
|
GO
|