Case Sensitive table name? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Case Sensitive table name?

Author

Topic

CanadaDBA

583 Posts

Posted - 2010-11-08 : 13:26:45

When I run the following:


SELECT TOP 100 * FROM GenHistory
SELECT TOP 100 * FROM GENHISTORY

The first query returns 100 rows while the second one generates an error.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'GENHISTORY'.

How come?

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-08 : 13:39:18

Because your collation is case sensitive. It'll require exact matches on the object names including case sensitivity.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources