locked
VS2010 T-SQL Intellisense RRS feed

  • Question

  • We have just started using VS2010, with the intention that all DB developers should migrate to using VS2010 for their database development instead of SSMS 2008. Many of the developers are primarily C# developers and greatly appreciate the intellisense help offered in SSMS 2008.

    Is there any way to improve the standard intellisense options within VS2010 T-SQL so that key words and data types are displayed when, say creating a new table. For many developers the ability to be prompted with context sensitive keywords (eg. when, say creating a new primary key constraint, or creating a select statement and the 'WITH' options are automatically prompted etc). The options seem somewhat limited at the moment in this area and do not compare with the functionality within SSMS2008. I have looked at the available configuration options but they don't seem to offer what I am looking for.

    Many thanks

    Regards

    Graham Goodwin

    Tuesday, April 27, 2010 11:49 AM

Answers

  • Hi Graham,

    You cant customize the intellisense as it is generated either from the database project's model or from a connected database. You can customize the snippets though. If you want to add or edit snippets you can do so from %Program Files%\Microsoft Visual Studio 10.0\VSTSDB\Snippets.

    Thanks,


    Barclay Hill Program Manager Visual Studio Data Tools (DataDude, DBPro, Database Edition, Database Projects, VS Data Tools) Please mark the responses as the answer if it resolves your question/issue. http://blogs.msdn.com/bahill
    • Marked as answer by grahamgoodwin Wednesday, May 5, 2010 3:23 PM
    Tuesday, May 4, 2010 7:32 PM
    Moderator

All replies

  • Hi Graham,

    You cant customize the intellisense as it is generated either from the database project's model or from a connected database. You can customize the snippets though. If you want to add or edit snippets you can do so from %Program Files%\Microsoft Visual Studio 10.0\VSTSDB\Snippets.

    Thanks,


    Barclay Hill Program Manager Visual Studio Data Tools (DataDude, DBPro, Database Edition, Database Projects, VS Data Tools) Please mark the responses as the answer if it resolves your question/issue. http://blogs.msdn.com/bahill
    • Marked as answer by grahamgoodwin Wednesday, May 5, 2010 3:23 PM
    Tuesday, May 4, 2010 7:32 PM
    Moderator
  • Google "SQL Assistant"
    Monday, April 11, 2011 9:25 PM