In SQL, which of the following is correct command for schema evolution, if the
In SQL, which of the following is correct command for schema evolution, if the
RESTRICT option is chosen than the schema is dropped only if schema has no
element in it?
Show answerHide answer
Correct answer: (D) DROP
Explanation
DROP SCHEMA name RESTRICT removes the schema only if it has no elements; CASCADE would drop it with all its contents.