Home Forums Article Discussions Article Discussions by Author Discuss content posted by Luis Martin Using Computed Columns RE: Using Computed Columns

  • February 14, 2019 at 1:50 pm

    #2022114

    thisisfutile - Wednesday, February 13, 2019 1:34 PM

    drew.allen - Tuesday, February 12, 2019 2:05 PM

    Also, you have your terminology a little mixed up.  The key field of a table MUST be unique.  So, status cannot be the "key field in the Customer table," because it is not unique in the customer table.

    Drew

    I'm sorry, I thought 'foreign' was understood, just as 'primary' is in your statement.

    The word primary is optional, because it's the default kind of key.  The word foreign is required, because it's not the default kind of key.  At least, that is my understanding of how the language works, and I haven't seen anything to indicate otherwise (although that could just be observational bias).

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA