Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2002
    Posts
    20

    Unanswered: upper/low case in table name

    Hi everybody,

    i've been seaching if the question has already been asked on the forum but found no answer.

    is it possible with SQL Server 2000 to query table without wondering if its name is upper or lower case ?
    For example :
    TABLENAME = TBTEST

    if i use a select from tbtest, i will get an error message. Is there a way to make it work ?

    Does it depend on the collaction sequence (although i'm not talking about the data stored in the table but the name of the table itself) ?

    It seems this behaviour was not present with SQL Server 7.

    Any ideas dudes ?

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Depends how the database or server was created.
    It can be case sensitive or insensitive.

  3. #3
    Join Date
    Mar 2002
    Posts
    20
    I thought the initial database/servers parameters was only concerning data, not the table names themselves.

    When the server was created i setup the server with the following parameters :

    French
    Binary sort

    So you say there is no issue to this problem although i re-create the database with correct parameters ?

  4. #4
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    Sort of.

    create database dddd collate Latin1_General_CI_AI

    will give you a case insensitive database so you can access tables irrespective of case in the identifier.

    Beware though as you will now have a database with a different collation to master and tempdb.
    Any temp tables will still be case sensitive.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •