In SQL, which of the following is correct command for schema evolution, if the…
2024
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?
- A.
DELETE
- B.
UPDATE
- C.
ALTER
- D.
DROP
Attempted by 157 students.
Show answer & explanation
Correct answer: D
With the RESTRICT option, the SQL DROP command drops a schema only when it has no dependent elements. Therefore the command is DROP.