How can we help you today? How can we help you today?

Suggestion: Layout should correct the case of keywords

For example: select field from table should be changed to SELECT field FROM table
simmonsp2
0

Comments

5 comments

  • rjpaulsen
    I agree.
    rjpaulsen
    0
  • amachanic
    Agreed! An option to automatically capitalize all keywords would be excellent.
    amachanic
    0
  • amachanic
    Another thing that would be cool:

    CREATE TABLE Xyz
    (
    Xyz_Id INT NOT NULL,
    myColumn VARCHAR(20)
    )


    ...


    select * from xyz where mycolumn = 'abc'

    ==

    SELECT * FROM Xyz WHERE myColumn = 'abc'

    (in other words, correct the capitalization for user-defined objects based on the capitalization actually used)
    amachanic
    0
  • Andras B
    amachanic wrote:
    Agreed! An option to automatically capitalize all keywords would be excellent.

    We are looking into this, and will try to add it.

    Andras
    Andras B
    0
  • Andras B
    amachanic wrote:
    Another thing that would be cool:

    CREATE TABLE Xyz
    (
    Xyz_Id INT NOT NULL,
    myColumn VARCHAR(20)
    )


    ...


    select * from xyz where mycolumn = 'abc'

    ==

    SELECT * FROM Xyz WHERE myColumn = 'abc'

    (in other words, correct the capitalization for user-defined objects based on the capitalization actually used)

    This one is a bit more tricky, but is certainly an interesting idea. There are still too many caseinsensitive servers around :). I'll save this for post version 1. Thank you for the idea

    Andras
    Andras B
    0

Add comment

Please sign in to leave a comment.