x

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

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?

When you're done, playing with this db, drop it.. Use Master; Drop Database IntellisenseTest

more ▼

asked Sep 12, 2011 at 08:31 AM in Default

avatar image

Raj More
1.8k 82 88 90

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

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 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.

more ▼

answered Sep 12, 2011 at 09:00 AM

avatar image

Shawn_Melton
6.5k 21 25 34

The trick being to get intellisense to stay off. I've turned mine off repeatedly (so it won't fight with red-gate sql prompt) and it just keeps going.

SQLEverywhere sidesteps that nicely.

Sep 12, 2011 at 10:12 AM KenJ
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x782
x440
x160
x6

asked: Sep 12, 2011 at 08:31 AM

Seen: 2776 times

Last Updated: Sep 12, 2011 at 08:41 AM

Copyright 2017 Redgate Software. Privacy Policy