Delete from stok;
Delete from sbaslik;
delete from sfatdetay;
delete from hizli;
delete from alfatbaslik;
delete from alfatdetay;
delete from brkd;
delete from carikart;
delete from cari where cid>6;
delete from gider;
delete from prntr;
delete from rafbarkodu;
delete from STSYMTBL;
delete from STKMVCT;
delete from STKOKUNAN;
delete from STKSONUC;
delete from STOKDRM;
delete from STSYMTBL;
delete from URMRG;
delete from satis_silinen;
Delete from ufiydeg;
UPDATE URUNLER SET uakpas='P',ustkgtar=current_date, usonsatfiy=0;
Delete from urunler where ubarkod like '1000146%';
Delete from urunler where ubarkod is null;
Delete from urunler where uad is null;
Delete from urunler where char_length(ubarkod)<8;
ALTER SEQUENCE GEN_ALFATBASLIK_ID RESTART WITH 1;
ALTER SEQUENCE GEN_ALFATDETAY_ID RESTART WITH 1;
ALTER SEQUENCE GEN_ALFEXCEL_ID RESTART WITH 1;
ALTER SEQUENCE GEN_BANKAHESAP_ID RESTART WITH 1;
ALTER SEQUENCE GEN_BRKD_ID RESTART WITH 14600000;
ALTER SEQUENCE GEN_CARIGRUP_ID RESTART WITH 1;
ALTER SEQUENCE GEN_CARIKART_ID RESTART WITH 1;
ALTER SEQUENCE GEN_CARI_ID RESTART WITH 6;
ALTER SEQUENCE GEN_GIDER_ID RESTART WITH 1;
ALTER SEQUENCE GEN_HIZLI_ID RESTART WITH 1;
ALTER SEQUENCE GEN_PRNTR_ID RESTART WITH 1;
ALTER SEQUENCE GEN_RAFBARKODU_ID RESTART WITH 1;
ALTER SEQUENCE GEN_SBASLIK_ID RESTART WITH 1;
ALTER SEQUENCE GEN_SFATDETAY_ID RESTART WITH 1;
ALTER SEQUENCE GEN_STKMVCT_ID RESTART WITH 1;
ALTER SEQUENCE GEN_STKOKUNAN_ID RESTART WITH 1;
ALTER SEQUENCE GEN_STKSONUC_ID RESTART WITH 1;
ALTER SEQUENCE GEN_STOKDRM_ID RESTART WITH 1;
ALTER SEQUENCE GEN_STOK_ID RESTART WITH 1;
ALTER SEQUENCE GEN_STSYMTBL_ID RESTART WITH 1 ;
ALTER SEQUENCE GEN_YARDIM_ID RESTART WITH 1 ;