Creating the supplier table

 

Assume that later you need a second table. This table contains information about suppliers of inventory items, which items they supply, and the cost of the item from that supplier. Create a table called SUPPLIERS in SAMPLELIB. This table has three columns: SUPPLIER_NUMBER, ITEM_NUMBER, and SUPPLIER_COST.

This table has a common column with the INVENTORY_LIST table: ITEM_NUMBER. Instead of creating a new ITEM_NUMBER column, you can copy the column definition used for ITEM_NUMBER in INVENTORY_LIST.

 

Parent topic:

Creating a table and defining a column