Intellisense and objects created on the fly - Simon Sabin UK SQL Consultant's Blog

Intellisense and objects created on the fly

I had an email from one the people that attends the usergroup I help run in London. She was suprised that when she had a create table statement intellisense is able to understand that this table is being created and provide intellisense on that table. This is just like any other object in your script, i.e. if you declare a variable then intellisense can provide that variable in a list for you. I guess tables are more complex than variables, but if with other languages like C# the intellisense is able to parse objects methods and even comments to provide information about those objects and methods without even compiling your code.

For a demo of this feature have a look at this nugget http://media.sqlknowhow.com/nuggets/Intellisense%20and%20objects%20created%20in%20scripts.wmv

 


-
Published 18 June 2009 10:03 by simonsabin

Comments

No Comments