How do I create a reference table from another table?

How do I reference one table to another table in SQL?

A FOREIGN KEY is a field (or collection of fields) in one table, that refers to the PRIMARY KEY in another table. The table with the foreign key is called the child table, and the table with the primary key is called the referenced or parent table.

How do you make a reference table?

Procedure1On the View Summary pane, click View Details.2Click Reference Tables > New Reference Table.3On the New Reference Table pane, type a Name for the reference table.4Select the type of reference table that you want to create.5Optional: In the Definition field, type a description for the reference table.

How do I transfer data from one table to another?

The SQL INSERT INTO SELECT Statement The INSERT INTO SELECT statement copies data from one table and inserts it into another table. The INSERT INTO SELECT statement requires that the data types in source and target tables match. Note: The existing records in the target table are unaffected.

What is a reference table example?

Example of a Reference Table. A reference table can be any table that contains information for other tables for example we can say Color is a reference table that contains different types of colors such as blue, white, green, etc.