Multiple choice technology databases

SQL87 error means?

  1. Invalid field name

  2. Invalid table name

  3. Invalid index name

  4. Invalid view name

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SQL87 specifically indicates an invalid table name error, meaning the SQL statement references a table that doesn't exist, is misspelled, or the user lacks permissions to access it. This is distinct from other object naming errors - options A, C, and D refer to fields, indexes, and views respectively, which would produce different error codes. The table name validation happens early in SQL parsing.