When to create a new table?

S

StargateFan

Is there any criteria that anyone here uses for deciding when to
create a new table or when one would just add info to an existing one?

Is there some sort of general guide or rule of thumb for this?

Thank you!
 
J

John Vinson

Is there any criteria that anyone here uses for deciding when to
create a new table or when one would just add info to an existing one?

Is there some sort of general guide or rule of thumb for this?

Thank you!
Click to expand...

You will need to create a new Table when your data model contains an
Entity which is not represented by an existing table.

If you're thinking of creating a new table with exactly the same
fields and structure as an existing table... the answer would be
Basically, Never.

John W. Vinson[MVP]
 
Top