what is a reference table?

Question

this is in relation to a database.

Answer 1

Hi there:

A ref table is a table generated to implement a many-to-many relationship. This table can be used as any other table. The main difference is that it does not contain data. Instead it contains references to the rows and columns in the original table. When you modify anything in the refrence table this means that you modified the data in the original table as well.


Hope this helps

Answer 2

A reference table is a type of table in a database. It stores information that changes relatively infrequently. The ID number of each record in the table is used throughout the site to refer to that record. It allows you to store the details about this data in only one place, which saves space and allows a singular place to store the data.

For example, if you have a reference table called COLORS with a COLOR_ID, it can also contain information about the name of the color, an HTML color code, etc. Then, any other table in the database can have a COLOR_ID, but to find out more about that color, you have to get the data from the COLORS reference table.

You don't have to use a numerical ID for the primary key of a reference table, but I used one for my example.

Answer 3

I recall it is a general term of a foreign table refer to in a relationship; the theory term is "foreign relation".

But if I'm mistaken, I would think deerpark's answer is closer to the real answer: but I thought that is "joint table"; such table contains no data as of any applicable value but simply to keep both sides of a relationship of cardinality many-many in Normalization (this is handy as normalization is tidy).

Answer 4

a refrence table is a table of info that u use somtimes in a project

Answer 5

Table to put dictionaries and encyclopedias on.