Ctrl+K Ctrl+Y Clears Bookmarks

dkusleika

I was looking for a shortcut to go to the next blank line. If I have, say, five select statements in a document I want to press Ctrl+Alt+Down (or something) to jump the next blank line which would be the line above the next select statement. I didn't find what I wanted so I resigned myself to adding bookmarks where I wanted them.

But my bookmarks kept disappearing and I realized that it was when I reformatted using Ctrl K Y (which I do all the time). It makes sense, I guess, that the bookmarks might not be in the same place so it's safer to get rid them.

Does anyone have good tips for jumping to key points in a large document other than bookmarks? Or is it a reasonable feature request to not clear bookmarks when reformatting?

dkim1999

Hi there,

Thank you for reaching out!

I do not think that there is a function on SQL Prompt to jump to key points.

You can try skimming through this documentation to see if anything fits your needs: https://docs.microsoft.com/en-us/sql/ssms/sql-server-management-studio-keyboard-shortcuts?view=sql-server-ver15

Regarding your issue with bookmarks disappearing, I am seeing the same issue.

You can input a feature request in the following link and it could be implemented: https://redgate.uservoice.com/forums/602209-redgate

Thank you!

Sincerely,

David Kim