0
Tagasi lükatud

Prevent creating columns with names, which prohibited by vendor

Vlad Beher 8 aastat tagasi uuendaja anonymous 8 aastat tagasi 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.

Vasta

Vasta
Tagasi lükatud

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.

Vasta
Tagasi lükatud

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.