Delete PeopleSoft Query From the Database

Delete PeopleSoft Query From the Database

 Pass QueryName as the parameter.

   SQLExec("DELETE FROM PSQRYDEFN WHERE QRYNAME=:1;
   SQLExec("DELETE FROM PSQRYSELECT WHERE QRYNAME=:1;
   SQLExec("DELETE FROM PSQRYRECORD WHERE QRYNAME=:1;
   SQLExec("DELETE FROM PSQRYFIELD WHERE QRYNAME=:1;
   SQLExec("DELETE FROM PSQRYFIELDLANG WHERE QRYNAME=:1;
   SQLExec("DELETE FROM PSQRYCRITERIA WHERE QRYNAME=:1;
   SQLExec("DELETE FROM PSQRYEXPR WHERE QRYNAME=:1;
   SQLExec("DELETE FROM PSQRYBIND WHERE QRYNAME=:1;
   SQLExec("DELETE FROM PSQRYBINDLANG WHERE QRYNAME=:1;
   /*Below tables are not available in older PS versions*/
   SQLExec("DELETE FROM PSQRYSTATS  WHERE QRYNAME=:1;
   SQLExec("DELETE FROM PSQRYEXECLOG WHERE QRYNAME=:1;
   SQLExec("DELETE FROM PSQRYFAVORITES WHERE QRYNAME=:1;