Multiple choice technology databases

Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Creating a foreign key constraint between columns of differing, incompatible data types (such as INT and VARCHAR) yields an error in SQL databases. The datatypes of the referencing column and the referenced column must match or be compatible.

Keep practicing — related questions