myPeopleSoft

PeopleSoft Community Network

Delete PeopleSoft Query

There are or could be different reason when we would like to delete any query from the databas. Beloe i have mentioned the SQL that are used to delete a query from the database.

   DELETE FROM PSQRYDEFN WHERE QRYNAME='Queryname';
   DELETE FROM PSQRYSELECT WHERE QRYNAME='Queryname';
   DELETE FROM PSQRYRECORD WHERE QRYNAME='Queryname';
   DELETE FROM PSQRYFIELD WHERE QRYNAME='Queryname';

Thanks.

3 members like this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Alene Kahre on September 10, 2013 at 9:29am

Thanks for sharing really usefull.

▶ Reply

Permalink Reply by kristen on July 9, 2017 at 12:28pm

it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.
Please write me on my email (captkristen899@gmail.com)