[Solved] Which of the following is a good practice when naming a foreign key constraint? — Ans: Start with FK, then table name, then referenced table name | SQL

SQL - Table Constraints

Which of the following is a good practice when naming a foreign key constraint?

AUse only numbers to name the constraint

BStart with FK, then table name, then referenced table name

CName it after the database server

DUse random letters without meaning

Step-by-Step Solution

Solution:

Step 1: Identify standard foreign key naming pattern
Foreign key constraints usually start with 'FK' followed by the table and referenced table names.
Step 2: Evaluate options for clarity and meaning
Only Start with FK, then table name, then referenced table name follows a meaningful, clear pattern that helps identify the constraint.
Final Answer:
Start with FK, then table name, then referenced table name -> Option B
Quick Check:
Foreign key naming pattern = A [OK]

Quick Trick: FK prefix + tables = clear foreign key name [OK]

Common Mistakes:

MISTAKES

Master "Table Constraints" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which of the following is a good practice when naming a foreign key constraint?