SELECT
  'DROP TABLE HRISDEV.dbo.' +name
FROM
  SYSOBJECTS
WHERE
  xtype = 'U'
  AND name LIKE '%_20%'

select * from PFM_PENILAIAN_PA_2018

DROP TABLE HRISDEV.dbo.SPG_REIMBURSEMENT_PROSES_20171208
DROP TABLE HRISDEV.dbo.SPG_HIRARKI_ORGANISASI_20211209
DROP TABLE HRISDEV.dbo.SPG_08_JABATAN_STR_20211213_0630
DROP TABLE HRISDEV.dbo.SPG_08_UNIT_ORGANISASI_20211213_0630
DROP TABLE HRISDEV.dbo.SPG_08_JABATAN_UNIT_20211213_0630
DROP TABLE HRISDEV.dbo.SPG_08_RIWAYAT_JABATAN_20211213_0630
DROP TABLE HRISDEV.dbo.SPG_PMK_20211213_0630
DROP TABLE HRISDEV.dbo.SPG_RIWAYAT_KEPANGKATAN_20211213_0630
DROP TABLE HRISDEV.dbo.SPG_08_UNIT_ORGANISASI_20230304
DROP TABLE HRISDEV.dbo.SPG_08_JABATAN_UNIT_20230304
DROP TABLE HRISDEV.dbo.SPG_HIRARKI_ORGANISASI_20230304
DROP TABLE HRISDEV.dbo.SPG_PMK_20230304
DROP TABLE HRISDEV.dbo.SPG_08_RIWAYAT_JABATAN_20230304
DROP TABLE HRISDEV.dbo.SPG_DATA_CURRENT_20230304
DROP TABLE HRISDEV.dbo.SPG_SK_20230304
DROP TABLE HRISDEV.dbo.SPG_PEGAWAI_20230304
DROP TABLE HRISDEV.dbo.SPG_REKAP_CUTI_20180103
DROP TABLE HRISDEV.dbo.SPG_PEGAWAI_PENSIUN_20230304
DROP TABLE HRISDEV.dbo.SPG_REKAP_CUTI_20180103_2
DROP TABLE HRISDEV.dbo.SPG_ADMIN_SATKER_20230306
DROP TABLE HRISDEV.dbo.SPG_08_UNIT_ORGANISASI_20211221
DROP TABLE HRISDEV.dbo.SPG_REKAP_CUTI_20180605
DROP TABLE HRISDEV.dbo.SPG_08_JABATAN_UNIT_20211221
DROP TABLE HRISDEV.dbo.SPG_CUTI_PEGAWAI_20230404
DROP TABLE HRISDEV.dbo.SPG_HIRARKI_ORGANISASI_20211221
DROP TABLE HRISDEV.dbo.SPG_08_JABATAN_UNIT_20170731
DROP TABLE HRISDEV.dbo.REC_ROOM_FORMASI_FUNCTIONAL_20230523
DROP TABLE HRISDEV.dbo.SPG_HIRARKI_ORGANISASI_20200611
DROP TABLE HRISDEV.dbo.SPG_HIRARKI_ORGANISASI_20170731
DROP TABLE HRISDEV.dbo.REC_PELAMAR_INTERNAL_20230526
DROP TABLE HRISDEV.dbo.REC_PELAMAR_INTERNAL_HISTORY_20230526
DROP TABLE HRISDEV.dbo.SPG_08_JABATAN_UNIT_20210413
DROP TABLE HRISDEV.dbo.REC_PELAMAR_AKTIFITAS_20230526
DROP TABLE HRISDEV.dbo.SPG_HIRARKI_ORGANISASI_20210413
DROP TABLE HRISDEV.dbo.PFM_PENILAIAN_201801
DROP TABLE HRISDEV.dbo.PFM_RIWAYAT_KINERJA_20180117
DROP TABLE HRISDEV.dbo.REC_PELAMAR_20210424
DROP TABLE HRISDEV.dbo.SPG_CUTI_PEGAWAI_20180122
DROP TABLE HRISDEV.dbo.SPG_REKAP_CUTI_20180808
DROP TABLE HRISDEV.dbo.REC_DOCUMENT_PELAMAR_20210421
DROP TABLE HRISDEV.dbo.TR_UPDATE_DATA_KELUARGA_20210525_1135
DROP TABLE HRISDEV.dbo.SPG_FORMASI_STRUKTURAL_20210527
DROP TABLE HRISDEV.dbo.REC_PTK_20210527
DROP TABLE HRISDEV.dbo.REC_RENCANA_PEMENUHAN_PEG_20220307
DROP TABLE HRISDEV.dbo.REC_PTK_20220307
DROP TABLE HRISDEV.dbo.SPG_FORMASI_STRUKTURAL_20220307
DROP TABLE HRISDEV.dbo.SPG_SKJ_NEW_BACKUP_20191203
DROP TABLE HRISDEV.dbo.REC_MPP_TARGET_20220307
DROP TABLE HRISDEV.dbo.REC_MPP_TARGET_COUNT_20220307
DROP TABLE HRISDEV.dbo.REC_ROOM_FORMASI_FUNCTIONAL_20220307
DROP TABLE HRISDEV.dbo.REC_ROOM_FORMASI_FUNCTIONAL_20220310
DROP TABLE HRISDEV.dbo.SPG_REIMBURSEMENT_PROSES_20180227
DROP TABLE HRISDEV.dbo.SPG_REKAP_CUTI_20190318
DROP TABLE HRISDEV.dbo.SPG_08_JABATAN_UNIT_20210609
DROP TABLE HRISDEV.dbo.SPG_08_UNIT_ORGANISASI_20180329
DROP TABLE HRISDEV.dbo.SPG_FORMASI_STRUKTURAL_20220328_2040
DROP TABLE HRISDEV.dbo.SPG_REKAP_CUTI_20181017
DROP TABLE HRISDEV.dbo.REC_PTK_20220328_2040
DROP TABLE HRISDEV.dbo.REC_MPP_TARGET_20220328_2040
DROP TABLE HRISDEV.dbo.REC_MPP_TARGET_COUNT_20220328_2040
DROP TABLE HRISDEV.dbo.REC_ROOM_FORMASI_FUNCTIONAL_20220328_2040
DROP TABLE HRISDEV.dbo.SPG_08_UNIT_ORGANISASI_20220330
DROP TABLE HRISDEV.dbo.temp_patching_20221130
DROP TABLE HRISDEV.dbo.SPG_FORMASI_STRUKTURAl_20220331
DROP TABLE HRISDEV.dbo.WF_OPKASUS_07092017
DROP TABLE HRISDEV.dbo.SPG_PEGAWAI_20221205
DROP TABLE HRISDEV.dbo.SPG_HIRARKI_ORGANISASI_20220331
DROP TABLE HRISDEV.dbo.SPG_REKAP_CUTI_20221205
DROP TABLE HRISDEV.dbo.REC_ROOM_FORMASI_FUNCTIONAL_20220331
DROP TABLE HRISDEV.dbo.PFM_RIWAYAT_KINERJA_20190322
DROP TABLE HRISDEV.dbo.SPG_08_JABATAN_UNIT_20221208
DROP TABLE HRISDEV.dbo.SPG_HIRARKI_ORGANISASI_20221208
DROP TABLE HRISDEV.dbo.SPG_RIWAYAT_KELUARGA_PEG_20221216
DROP TABLE HRISDEV.dbo.SPG_08_RIWAYAT_JABATAN_20190503
DROP TABLE HRISDEV.dbo.SPG_PMK_20190503
DROP TABLE HRISDEV.dbo.SPG_CUTI_PEGAWAI_20181116
DROP TABLE HRISDEV.dbo.REC_PELAMAR_INTERNAL_20210618_1705
DROP TABLE HRISDEV.dbo.SPG_08_UNIT_ORGANISASI_20181204
DROP TABLE HRISDEV.dbo.REC_PELAMAR_INTERNAL_HISTORY_20210618_1705
DROP TABLE HRISDEV.dbo.SPG_08_RIWAYAT_JABATAN_20181205
DROP TABLE HRISDEV.dbo.SPG_JNS_SURAT_TUGAS_20180418
DROP TABLE HRISDEV.dbo.REC_PELAMAR_AKTIFITAS_20210618_1705
DROP TABLE HRISDEV.dbo.SPG_PEGAWAI_ELIGIBLE_20210620
DROP TABLE HRISDEV.dbo.OPS_FIELD_20210622
DROP TABLE HRISDEV.dbo.SPG_08_JABATAN_UNIT_20190806
DROP TABLE HRISDEV.dbo.SPG_REKAP_CUTI_11012017
DROP TABLE HRISDEV.dbo.SPG_REKAP_CUTI_20210627
DROP TABLE HRISDEV.dbo.WF_OPKASUS_20170111
DROP TABLE HRISDEV.dbo.PFM_RIWAYAT_KINERJA_20170111
DROP TABLE HRISDEV.dbo.REC_PELAMAR_INTERNAL_20220420
DROP TABLE HRISDEV.dbo.SPG_REKAP_CUTI_17012017
DROP TABLE HRISDEV.dbo.WF_MENU_20201208
DROP TABLE HRISDEV.dbo.REC_PELAMAR_INTERNAL_HISTORY_20220420
DROP TABLE HRISDEV.dbo.SPG_CUTI_PEGAWAI_17012017
DROP TABLE HRISDEV.dbo.REC_PELAMAR_AKTIFITAS_20220420
DROP TABLE HRISDEV.dbo.SPG_DATA_CURRENT_24012017
DROP TABLE HRISDEV.dbo.REC_PELAMAR_20220524
DROP TABLE HRISDEV.dbo.REC_DOCUMENT_PELAMAR_20220525
DROP TABLE HRISDEV.dbo.SPG_CUTI_PEGAWAI_20220628
DROP TABLE HRISDEV.dbo.SPG_FORMASI_STRUKTURAl_20210824
DROP TABLE HRISDEV.dbo.SPG_CUTI_PEGAWAI_20220710
DROP TABLE HRISDEV.dbo.REC_PTK_20210824
DROP TABLE HRISDEV.dbo.SPG_08_UNIT_ORGANISASI_20220721
DROP TABLE HRISDEV.dbo.SPG_08_UNIT_ORGANISASI_20220722
DROP TABLE HRISDEV.dbo.SPG_RIWAYAT_KELUARGA_PEG_20220727
DROP TABLE HRISDEV.dbo.SPG_HIRARKI_ORGANISASI_20210924
DROP TABLE HRISDEV.dbo.SPG_08_JABATAN_UNIT_20180516
DROP TABLE HRISDEV.dbo.SPG_CUTI_PEGAWAI_20220921
DROP TABLE HRISDEV.dbo.WF_OPKASUS_20230102
DROP TABLE HRISDEV.dbo.SPG_NILAI_SKJ_20210113
DROP TABLE HRISDEV.dbo.SPG_08_UNIT_ORGANISASI_20230131