SQL - Table Constraints
Given the following constraint name on table
Invoices: PK_Invoices, what type of constraint is this likely to be?Given the following constraint name on table Invoices: PK_Invoices, what type of constraint is this likely to be?
medium📝 query result Q4 of 15
Step-by-Step Solution
Solution:
Step 1: Understand common prefix conventions
PK prefix is commonly used for Primary Key constraints.Step 2: Match prefix to constraint type
Since the name starts with PK, it indicates a Primary Key constraint on the Invoices table.Final Answer:
Primary Key constraint -> Option DQuick Check:
PK prefix means Primary Key = A [OK]
Quick Trick: PK prefix means primary key constraint [OK]
Common Mistakes:
MISTAKES- Confusing PK with FK
- Assuming PK means unique constraint
- Ignoring prefix meaning
Master "Table Constraints" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes