What are the challenges you face when working across database platforms? Take the survey
Options

"Modify" and "Newname" do not convert to uppercase

Wyatt70Wyatt70 Posts: 50
edited July 2, 2007 12:20PM in SQL Prompt Previous Versions
The keywords "MODIFY" and "NEWNAME" are not being converted to uppercase as I would like.

I entered the following statement in Management Studio:
ALTER DATABASE Test
modify FILE (
NAME = 'Test_Data',
newname = 'NewTest_Data');

Are these not considered keywords in SQLPrompt, or is there a setting I need to change? All other keywords are converting to uppercase, as I intended.

Comments

  • Options
    This is definatly a bug. Unfortinatly there is no setting you can tweek to get this behaviour at the moment. Hopefully we will have a fix in SQL Prompt 3.5
    Software Engineer
    Red Gate Software
  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    I can confirm that we've fixed this in 3.5.
    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.