CODEWITHSUNDEEP
databasedatabase-schema
mr.wolle
mr.wolle

Reputation: 1336

Multidimensions in a database

I have several same structured tables with config information. E.g. table1, table2... The amount of tables is dynamic. Is there a way of storing these configurations in a database without making a new (same structured) table for each configuration ?

Upvotes: 0

Views: 30

Answers (1)

Tony Hopkinson
Tony Hopkinson

Reputation: 20320

Create one table.

If TableA is (ID, Name, Value) and TableB is (ID, Name, Value)

TableAll is (ID, TableType, Name, Value)

for example.

Upvotes: 1

Related Questions