How can we improve SQL Prompt?

Jump to object explorer

I just had a situation where I was in code, didn't have the object explorer opened up for the connection and wanted to look at the table properties, security etc.

It would be really good if you good offer up a "go to object in object explorer" feature - similar to the F12 shortcut to load an ALTER tab, but just changes the object explorer focus to the object that I am currently at.

Hi Aaron, thank you for this awesome news. I forgot to mention: If the considered object is a synonym, then CTRL-F12 should directly jump to its base object - and context menu should offer both ways: Jumping to the synonym itself or to the base object.

I want to push this feature, since SQL Search now has "Go to object explorer". It would be great, if SQL Prompt offered such an option in context menu upon right-clicking an object in script window and object popup window (now available: Script/Summary & Copy).

It's not quite what you're asking, but if FOO is a stored procedure, function or view then F12 will script the object as an ALTER statement in a new query window. It's also "Script as ALTER" on the context menu. It's not implemented for tables though, partly because it's not clear what this should do. Should it open a CREATE TABLE script (which can't be executed) or an ALTER TABLE script (which won't tell you the current definition)?

I'm sorry Sandro -- this feature wasn't implemented due to other priorities, but we neglected to change the status here to reflect that. I'll do that now. This is something we're keen to add to SQL Search in due course, but we have no fixed dates at the moment.