Explore BrainMass

Explore BrainMass

    This posting addresses primary keys using SQL.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Explain two methods for defining a primary key using SQL.

    © BrainMass Inc. brainmass.com June 4, 2020, 2:32 am ad1c9bdddf
    https://brainmass.com/business/management-information-systems/defining-primary-key-using-sql-465030

    Solution Preview

    Two methods for defining a primary key using SQL are to define the primary key at the column level, and to define the primary key at the table level. When the user defines the primary keys, it is called a constraint. Constraints can be "specified immediately after the column definition", which is a column-level constraint and is used in defining a column-level primary key (Beginner SQL, 2011). The constraint can then be further specified ...

    Solution Summary

    The solution provides a detailed discussion that describes two methods for defining a primary key using SQL. References are also provided.

    $2.19

    ADVERTISEMENT