How to restore droped store procedure in intellij idea?
Answered
I have implement store procudure which is very complex. but accidently it was dropped by me. How can I restore it? is it possible? i have used mssql.
Please sign in to leave a comment.
the only way is to find out executed script in one of console files. In Project files window navigate to Scratches & Consoles -> Database Consoles -> your_data_source and check every file. Also you can right-click on any file and go to Local History - you can also check for changes in file.
Hope this helps.