I have tried out SSDT Database project in Visual Studio, and with the SQL Prompt solution from Red Gate. It seems that the intellisense only works for SQL keywords like SELECT, WHERE etc, it does not provide intellisense for table names, column names etc.

Is there a trick to get this working? (Tried in both VS2015 and VS2017).

2 Answers 2


Unfortunately SQLPrompt works on the connection to a database and not the database project. If you deploy your DB then SQLPrompt can pick it up the schema.

Its on the backlog as a research item currently https://www.red-gate.com/products/sql-development/sql-prompt/roadmap.

If you want project based intellisense then you need to disable SQL Prompt in VS

  • Hi. Just a quick question. I tried deploying, but still no intellisense via SQLPrompt with table-names or column-names. Do you know where/how I can check what connection is in use?
    – GHauan
    May 31, 2017 at 12:28

Got a feedback from Red Gate that this does not work in Visual Studio yet.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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