I have data in SQL History going back to 2015. I would like to archive or delete history older than 24 months. Is there a way to achieve this? Thank you
Unfortunately, there's no built-functionality within SQL Prompt. However, the SqlHistory.db file can be viewed and edited by third-party tools like SQLite Browser (https://sqlitebrowser.org/dl/).
Answers
Thank you for reaching out.
Unfortunately, there's no built-functionality within SQL Prompt. However, the SqlHistory.db file can be viewed and edited by third-party tools like SQLite Browser (https://sqlitebrowser.org/dl/).
Let me know if you have any other questions.