Files
ware_house/rollback_online_history_forms_patch.sql

25 lines
651 B
Transact-SQL

/*
Rollback online - form storiche Python
Rimuove solo le viste Python-only usate dalla form "Storico Picking List".
Non tocca oggetti C# legacy e non tocca dati.
Nota:
- la form "Storico movimenti UDC" non ha oggetti dedicati da rimuovere.
*/
IF OBJECT_ID(N'dbo.py_XMag_ViewPackingListStorico', N'V') IS NOT NULL
DROP VIEW dbo.py_XMag_ViewPackingListStorico;
GO
IF OBJECT_ID(N'dbo.py_vPreparaPackingList', N'V') IS NOT NULL
DROP VIEW dbo.py_vPreparaPackingList;
GO
IF OBJECT_ID(N'dbo.py_vPreparaPackingListSAMA1', N'V') IS NOT NULL
DROP VIEW dbo.py_vPreparaPackingListSAMA1;
GO
PRINT 'Rollback form storiche Python completato.';
GO