Bilnex V3 Veritabanındaki Bütün Hareketleri Silen Sql Sorgusu
Önemli Not: Bu işlem veritabanındaki bütün hareketleri geri getirilemeyecek şekilde siler.
EXEC sp_msforeachtable 'ALTER TABLE ? DISABLE TRIGGER ALL'
DELETE FROM BANKA_HAR
DELETE FROM BANKA_ISLEM
DELETE FROM BANKA_ISLEM_DT
DELETE FROM CARI_HAR
DELETE FROM CARI_HAREKET_KAPAMA
DELETE FROM FATURA
DELETE FROM FATURA_DT
DELETE FROM FATURA_TAHSILAT
DELETE FROM FATURA_VADELERI
DELETE FROM FIYAT_DEGISIKLIGI
DELETE FROM FIYAT_DEGISIKLIGI_DT
DELETE FROM HIZMET_HAR
DELETE FROM IRSALIYE
DELETE FROM IRSALIYE_DT
DELETE FROM KASA_HAR
DELETE FROM KASA_ISLEM
DELETE FROM KASA_ISLEM_DT
DELETE FROM MASRAF_HAR
DELETE FROM MASRAF_MALIYET_DAGITIM
DELETE FROM MUHASEBE_FIS
DELETE FROM MUHASEBE_FIS_HAR
DELETE FROM MUSTAHSIL_EMANET
DELETE FROM MUSTAHSIL_EMANET_DT
DELETE FROM MUSTAHSIL_HIZMET_FISI
DELETE FROM MUSTAHSIL_HIZMET_FISI_DT
DELETE FROM MUSTAHSIL_KESINTI
DELETE FROM MUSTAHSIL_MAKBUZU
DELETE FROM MUSTAHSIL_MAKBUZU_DT
DELETE FROM MUSTAHSIL_URUNALIS
DELETE FROM PERSONEL_HAR
DELETE FROM PERSONEL_PRIM
DELETE FROM PERSONEL_PUANTAJ
DELETE FROM PERSONEL_PUANTAJ_DETAY
DELETE FROM PERSONEL_PUANTAJ_DONEM
DELETE FROM POS_SATIS
DELETE FROM POS_SATIS_CALISMA_DONEMLERI
DELETE FROM POS_SATIS_DT
DELETE FROM POS_SATIS_TAHSILAT
DELETE FROM POSKASA_FIS
DELETE FROM POSKASA_TEXT
DELETE FROM PROJE_HIZMET_FISI
DELETE FROM PROJE_HIZMET_FISI_DT
DELETE FROM RENK_BEDEN_HAR
DELETE FROM SIPARIS
DELETE FROM SIPARIS_DT
DELETE FROM SMMAK
DELETE FROM SMMAK_DT
DELETE FROM STA_SOZLESME
DELETE FROM STA_SOZLESME_DT
DELETE FROM STGORUSME_ASAMALAR
DELETE FROM STGORUSME_HAREKETLER
DELETE FROM STGORUSME_TANIMLAR
DELETE FROM STL_ISTEK
DELETE FROM STL_ISTEK_DT
DELETE FROM STOK_FIS
DELETE FROM STOK_FIS_DT
DELETE FROM STOK_HAR
DELETE FROM STOK_SAYIM
DELETE FROM STOK_SAYIM_DT
DELETE FROM STOK_SERINO_HAR
DELETE FROM TAHODEME
DELETE FROM TAHODEME_DT
DELETE FROM TAKSIT
DELETE FROM TEKLIF
DELETE FROM TEKLIF_DT
DELETE FROM URETIM_FISI
DELETE FROM URETIM_FISI_DT
DELETE FROM URETIM_FISI_DT_HAR
DELETE FROM URETIM_IS_EMRI
DELETE FROM URETIM_PLANLAMA
DELETE FROM URETIM_TAKIM
DELETE FROM URETIM_TAKIM_DT
EXEC sp_msforeachtable 'ALTER TABLE ? ENABLE TRIGGER ALL'