Online Documentation


Create referencing column

 

This option is often used for normalizing tables. When badly designed (or old) database has character columns refererencing equivalent column in other tables, it is desirable to reference the other table by it's primary key. This option first test referenced data for validity and then creates a new integer column referencing another table's primary key matched by selected column.

create-ref-column