SSMS: Intellisense doesn't support CTEs - by Jamie Thomson

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 307645 Comments
Status Closed Workarounds
Type Suggestion Repros 1
Opened 10/30/2007 5:04:45 PM
Access Restriction Public


I am using the MVP-only pre-CTP5 release.

Intellisense doesn't support CTEs. Typing CTRL-J inside a WITH block doesn't bring up the candidate list as it does outside the WITH block.

Also, if I am using the CTE within a SQL statement the columns in the CTE are not available in the candidate list. I know this is because the metadata of a CTE doesn't exist in the system catalog but no matter, I'd still really like to see this functionality added.
Sign in to post a comment.
Posted by Jamie Thomson on 11/18/2007 at 9:53 AM
Great stuff. Thanks Ken.
Posted by Ken [MSFT] on 11/18/2007 at 9:50 AM
Hi Jamie,

CTE support is coded and will be available in our CTP 6 release. Thanks again for submitting this request and I look forward to your feedback on the functionality.

Best regards,
Posted by Jamie Thomson on 11/5/2007 at 5:15 PM
thats great. thanks ken.
Posted by Ken [MSFT] on 11/5/2007 at 9:10 AM
Hi Jamie,

Thank you for submitting this. I will discuss the suggestion with the team and see what we might be able to do regarding CTE support and let you know.

Best Regards,
Posted by AaronBertrand on 10/31/2007 at 10:52 AM
Pretty sure Bill R. told us that intellisense was only valid for SELECT. While that may imply that CTEs should or should not be included, I think it is understandable that if there are technical limitations preventing delivery on other DML statements, that we shouldn't expect it within CTEs either. ;-)