There could be different reasons we would like to delete a query from the database. Below are the SQL that are needed to delete a query from 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';
1 comment:
Thankyou friend for sharing this peoplesoft query
Post a Comment