> In my db I have about one hundred tables like this:
>
> code
> description
>
> To avoid to have a so great number of similar tables in the db
> I wonder if it is a good idea to unify all these tables in one big
> table like this:
>
> id
> code
> table_ name
> description
Bad idea.
E.g. how d
Yes. The general rules are:
Many normalized tables. OK.
Denormalizing simply to reduce the number of tables. Not OK.
- Bob
On Mon, Jan 28, 2013 at 1:47 PM, Kevin Grittner wrote:
> Jose Soares wrote:
>
> > In my db I have about one hundred tables like this:
> >
> > code
> > description
>
Jose Soares wrote:
> In my db I have about one hundred tables like this:
>
> code
> description
>
> To avoid to have a so great number of similar tables in the db
> I wonder if it is a good idea to unify all these tables in one
> big table like this:
>
> id
> code
> table_ name
> description
> C
Jose Soares wrote:
> I have a question about database design best pratice.
>
> In my db I have about one hundred tables like this:
>
> code
> description
>
> To avoid to have a so great number of similar tables in the db
> I wonder if it is a good idea to unify all these tables in one big table
I'll answer with the same things I did on the Oracle list :)
code
description
To avoid to have a so great number of similar tables in the db
I wonder if it is a good idea to unify all these tables in one big table
like this:
id
code
table_ name
description
The advantages are:
1. only one tab
