ishita wants to delete a table along with its contents using sql command. suggest her command to accomplish the task??
a) drop
b) delete
c) A or B
d) both
Answers
Answered by
9
Answer:
BOTH IS THE ANSWER
Explanation:
BOTH IS THE ANSWER
MARK AS BRAINLIEST ANSWER
Answered by
1
The (a)drop command will accomplish the task successfully.
Explanation:
- The DROP command in SQL is used to delete entire tables and relations.
- This can change the structure of a schema and hence is considered a DDL (data definition language) command.
- The DELETE command in SQL is used to remove a row or tuple from a table.
- This does not change the structure of a schema and only the data values. Hence, it is considered a DML (data manipulation language) command.
- Here the task is to delete the entire table including its content and structure. Hence, this is a data definition level task.
- Therefore, DROP <table_name> command should be used.
Similar questions