Delete PeopleSoft Query From the Database

There could be different reasons why a PeopleSoft developer would like to delete a query from the database. Upgrade clean up would probably be the most common one. Here is a function you can use to get you started.

 

Function DeleteQuery(&sQueryName As string) SQLExec("DELETE FROM PSQRYDEFN WHERE QRYNAME=:1", &sQueryName); SQLExec("DELETE FROM PSQRYSELECT WHERE QRYNAME=:1", &sQueryName); SQLExec("DELETE FROM PSQRYRECORD WHERE QRYNAME=:1", &sQueryName); SQLExec("DELETE FROM PSQRYFIELD WHERE QRYNAME=:1", &sQueryName); SQLExec("DELETE FROM PSQRYFIELDLANG WHERE QRYNAME=:1", &sQueryName); SQLExec("DELETE FROM PSQRYCRITERIA WHERE QRYNAME=:1", &sQueryName); SQLExec("DELETE FROM PSQRYEXPR WHERE QRYNAME=:1", &sQueryName); SQLExec("DELETE FROM PSQRYBIND WHERE QRYNAME=:1", &sQueryName); SQLExec("DELETE FROM PSQRYBINDLANG WHERE QRYNAME=:1", &sQueryName); /*Below tables are not availabe in older PS versions*/ SQLExec("DELETE FROM PSQRYSTATS WHERE QRYNAME=:1", &sQueryName); SQLExec("DELETE FROM PSQRYEXECLOG WHERE QRYNAME=:1", &sQueryName); SQLExec("DELETE FROM PSQRYFAVORITES WHERE QRYNAME=:1", &sQueryName); End-Function;

Of course, deleting by Query Name is not the only available option. So, feel free to modify the function to fit your needs.