Multiple choice technology databases

Which will not allow to drop a table?

  1. (a) UNION

  2. (b) SCHEMABINDING

  3. (c) CHECK OPTION

  4. (d) All
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SCHEMABINDING on a view or function creates a dependency that prevents dropping the underlying tables. When an object is schema-bound, SQL Server ensures the object's definition remains valid by blocking any changes to referenced schema elements. This means you cannot DROP a table that a schema-bound view references - you must first drop or alter the schema-bound object. UNION and CHECK OPTION are view options that don't prevent dropping tables.

Keep practicing — related questions