SQl Complete - column alias lower case

[mrozik221]

After formatting (6.5.23 version)
f.Name AS FileName
becomes always
f.Name AS filename

How can I prevent it - leave oryginal state?
Regards

[alexa]

If there are multiple identifiers with identical names but different case, dbForge remembers the first found identifier's case and uses it when formatting the document. This is by design.

You can avoid this by setting up dbForge as follows:
1. Select 'SQL Complete -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Formatting -> Profiles' branch.
3. Select the active profile and click the 'Open Selected...' button.
4. Expand the 'Text Case -> Identifier Case' node.
5. Select the 'Do not change' option.
6. Click 'OK'.

The 'Do not change' option leaves the identifier in that case, in which it was typed in the script.

[mrozik221]

Not 'Identifier Case' but 'Alias Case' - it works - thank you!

[alexa]

Sorry for the confusion.

That's right.

Thank you for the update.