best practices on naming tables

Posts   
 
    
JayBee
User
Posts: 269
Joined: 28-Dec-2006
# Posted on: 08-Aug-2014 20:56:38   

Somewhere in the 4.2 documentation it is stated that one should not use tablenames with a prefix. Putting a prefix in front of a table name is common practice in some of the environments I have been working. This helps seperating between data maintained within certain subsystems.

So, what would be a better practice? Use different schemes?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 09-Aug-2014 08:14:17   

JayBee wrote:

So, what would be a better practice? Use different schemes?

The thing is that LLBLGen would strip your prefixes (this is configurable), but that might not give you the names you want. So you have to decide whether to strip off your prefixes on db, or rename one by one in your model, or use schemas. All depends on your real options in your scenario.

David Elizondo | LLBLGen Support Team
JayBee
User
Posts: 269
Joined: 28-Dec-2006
# Posted on: 14-Aug-2014 08:37:29   

Each of the files starts with a 3 letter prefix followed by an underschre. In the project configuration settings I define the strip pattern. Works fine for me.