Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is there a way to temporarily suppress SQL Server Management Studio's auto-complete while typing a query? I don't want to disable auto-complete completely just say hold down some key while typing in a particular word so that it doesn't get in the way.

For example say I had the following query

SELECT Foo, Foo2 FROM SomeTable

As I type Foo and then hit space-bar SQL Server Management Studio's auto-complete kicks in and completes Foo to FooBar.

share|improve this question

migrated from stackoverflow.com Jun 27 '12 at 20:26

This question came from our site for professional and enthusiast programmers.

6  
You will find that IntelliSense in SQL Server 2012 Management Studio is much less aggressive. I can't stand it in 2008 - if there is a column named ID it gets changed to IDENT_CURRENT. Puke. –  Aaron Bertrand Jun 26 '12 at 20:29
    
@AaronBertrand - Does hitting space or comma still auto complete? I find that very annoying as I'm used to having to tab for that in other environments and 95% of the time it auto completes to something that I then need to delete the end of. –  Martin Smith Jun 26 '12 at 20:34
    
@MartinSmith for space and comma, they are interpreted as they should be, unless you use the down-arrow to highlight the obvious selection (this is one keystroke), then hit space or comma. Tab picks the option SSMS thinks you meant. And the algorithm for "best choice" is 1000X better than 2008/2008 R2. The best part to me is partial match. type sys.depend and the auto-complete list is filtered to all DMVs/catalog views that contain depend. –  Aaron Bertrand Jun 26 '12 at 20:39
    
@MartinSmith or, in one sentence, I think the functionality in 2012 is a lot more intuitive and works the way you would expect. –  Aaron Bertrand Jun 26 '12 at 20:40
    
Thanks I was wondering how the the intelliSense worked in SQL Server 2012 Management Studio, I thought I can't be the only one who finds it to be to aggressive. –  Jack Jun 26 '12 at 20:42

1 Answer 1

up vote 9 down vote accepted

Hit ESC to close the window when done typing the word before hitting space, but if you hit ESC after 'fo' and then type 'o' it will kick in again.

Another option if you don't use it often would be to disable it (Tools->Options->Text Editor->Transact-SQL->General->Auto list members) and use CTRL+J to bring it up manually when you want to use it. Red Gate also has a product called SQL Prompt which might offer more control.

In addition there is an "Intellisense Enabled" option under the Query menu and on the Query toolbar if you want to temporarily disable/enable it.

share|improve this answer
    
(This also works in other MS tools like VS.) –  pst Jun 26 '12 at 20:28
    
Thanks, but its still super annoying for names that contain spaces ([Foo Bar] for example) since as you mentioned it kicks in again so you end up needing to keep hitting ESC. I'm going to leave the question open a bit longer before accepting to see if anyone know of a different solution. –  Jack Jun 26 '12 at 20:40
    
I agree, I don't think autocomplete should be enabled in a select clause unless you already have your from tables specified. –  Jason Goemaat Jun 27 '12 at 19:05

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.