1

Is it possible to hide tables or other objects from popping up on SSMS' IntelliSense?

For example, I have the following tables

Patient

Patient_history

Patient_daily

I would like to only see patient pop up in my IntelliSense. Is this possible?

  • This might work: sqlstudies.com/2017/04/03/… – Max Vernon Oct 26 '17 at 21:44
  • 1
    @MaxVernon Tried, only hides from object explorer, not intellisense. – Anthony Genovese Oct 26 '17 at 22:24
  • 1
    @AnthonyGenovese - While being a complete kludge and not directly related to SSMS, if you specifically deny SELECT authority on those 2 objects to your login, Intellisense will not show you (at least in my testing) those objects during auto-complete. From Troubleshooting IntelliSense, 'Completion lists do not include database objects for which you do not have permissions' – Scott Hodgin Oct 27 '17 at 9:33
  • @ScottHodgin Hmmm, that would mean I would have to give myself permission again during our daily loads. Then remove permissions once I am done. It kinda works. Ideally, I would still like to have access to those tables. I just don't need to see them while I write 98% of my daily queries. – Anthony Genovese Oct 27 '17 at 14:07
  • 1
    @AnthonyGenovese - I completely understand and it's a total hack - i just wanted to mention it. – Scott Hodgin Oct 27 '17 at 14:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.