0
Declined

Prevent creating columns with names, which prohibited by vendor

Vlad Beher 4 years ago updated by Michał Kołodziejski 4 years ago 1

Hello!

May be it is good idea to prevent creating columns with name , e.g. Date .
I didn't know, that Oracle doesn't like such names.. And may be there is list with such names, which are not permitted to use in one database or another.

Answer

Answer
Declined

Hi, thanks for sharing your idea. That's true that you generally cannot use keywords as objects identifiers. But if you quote them, you can. This way you can have a column called "date"

You can find this option in "Model properties" (on the right-hand side when nothing is selected on diagram) in "SQL generation settings" section. It's called "Quote all SQL identifiers."

I hope this helps.

Answer
Declined

Hi, thanks for sharing your idea. That's true that you generally cannot use keywords as objects identifiers. But if you quote them, you can. This way you can have a column called "date"

You can find this option in "Model properties" (on the right-hand side when nothing is selected on diagram) in "SQL generation settings" section. It's called "Quote all SQL identifiers."

I hope this helps.