Is SQL case sensitive?

1137475 pts.
Tags:
SQL
Does anyone know if SQL case is sensitive (syntax). I'm using MySQL and SQL Server and I find that it's case in-sensitive in both. Thanks for the help.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

keywords in  are case insensitive but table and column names are case-sensitive

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • CharlieBrowne

    The field values are case sensitive. That's why we use the keyword UPPER. The command itself is not.

    SELECT * FROM TABLE1

    will work just the same as

    Select * from TaBlE1

    62,385 pointsBadges:
    report
  • carlosdl
    In general I agree with Carlie.

    The keywords are always case-insensitive, but column and table names can be case-sensitive depending on the database being used and how they are declared, so the above example is not guaranteed to work on all systems (because of the case in the table name).
    84,720 pointsBadges:
    report
  • JustinWilson07
    It depends on the database being used and how they are declared.
    2,465 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: