Which SQL command would you use to completely remove a table named employees and all of its data from a relational database?
DELETE FROM employees;
REMOVE TABLE employees;
TRUNCATE TABLE employees;
DROP TABLE employees;
The DROP TABLE command is used to completely remove an existing table from a database, along with all the data it contains. This action cannot be undone, and the table structure is also removed. The DELETE command would remove the data but leave the table structure intact. The TRUNCATE TABLE command removes all rows from a table but also leaves the table structure intact. The REMOVE TABLE command does not exist in SQL.
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
All Information Technology Package plans include the following perks and exams.
Our pricing is simple. Full access to all certifications and exams in each package, for one price.
As many practice tests for as many topics as you want.
Use study mode non-stop, no limits.
Access to our AI assistant, Bash, trained to help you pass your exam.
Track your scores over time in study mode and report cards.
See how you improve over time, and where you need to focus.
Access our store with even bigger discounts than before.
Unlimited access to all performance questions and be prepared for the real thing.
All Information Technology Package plans include unlimited access to the following study materials.
Create an account or sign in to access our study materials.