asked
Making Intellisense Case Insensitive
The Intellisense drop down is case-sensitive while writing TSQL for 2008-R2. Here is a sample script to create a database and create tables Use master GO Create Database IntellisenseTest Go Use IntellisenseTest GO Create Table tblProductscustomer( Id Integer Identity (1,1)) Create Table tblProductsCustomerDV( Id Integer Identity (1,1)) Create Table tblProductscustomeraddress( Id Integer Identity (1,1)) Create Table tblProductscustomerOrder( Id Integer Identity (1,1)) GO Then, type **Ctrl+Shift+R** to refresh the Intellisense Cache and then do a simple select select * from IntellisenseTest.dbo. You should get a list of tables as shown below (address is after Order because of case sensitivity) ![alt text][1] These lists are sorted case-sensitive although the server and database collations are both set to Case-Insensitive. What do I do to fix this issue? [1]: /upfiles/20110912_11-17-29_AM_bad_sort_order.png When you're done, playing with this db, drop it.. `Use Master; Drop Database IntellisenseTest`
It appears this was reported on Microsoft Connect for SQL Server: [
http://connect.microsoft.com/SQLServer/feedback/details/672196/t-sql-is-not-case-sensitive-but-t-sql-intellisense-is][1] It is marked Fixed but from the answer it seems it will be fixed in Denali. The workaround offered seems to be just turning off Intellisense **Edit**: Not to push any particular product or anything, but I have played with [SQLeverywhere][2] a few times and the intellisense in that product seems to work much better than SSMS. Although I have not tried it on databases with non-default collations set. [1]:
http://connect.microsoft.com/SQLServer/feedback/details/672196/t-sql-is-not-case-sensitive-but-t-sql-intellisense-is [2]:
http://www.atlantis-interactive.co.uk/products/sqleverywhere/default.aspx
