- Vertabelo
-
Ideed
0
Tagasi lükatud
Prevent creating columns with names, which prohibited by vendor
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.
Customer support service by UserEcho
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.