You need to delete a database table.
Which data definition language (DDL) keyword should you use?
You need to delete a database table.
Which data definition language (DDL) keyword should you use?
To delete a database table, the correct data definition language (DDL) keyword to use is DROP. The DROP command removes the table definition and all of its contents from the database entirely. ALTER is used to modify an existing database object, DELETE removes rows from a table but does not delete the table itself, and TRUNCATE removes all rows from a table but keeps the table structure intact.
The answer is C. TRUNCATE does not remove a table: it deletes all the rows of that table, leaving the object (the table) in the database.
But it’s says you need to delete a table so I feel like drop is the correct answer... If it’s say you need to delete data then truncate ...
drop is correct
Drop is the correct answer
the answer is drop.
The answer is D
No xD?
C. DROP is correct