W3. SQL Delete

Question 1

Q: What is the purpose of the SQL DELETE statement?

Answer 1

A: To delete existing records from a table.

Question 2

Q: What is the syntax for the DELETE statement with a condition?

Answer 2

DELETE FROM table_name 
WHERE condition;

Question 3

Q: Why is the WHERE clause important in a DELETE statement?

Answer 3

A: It specifies which records to delete; omitting it deletes all records in the table.

Question 4

Q: Write an example query to delete a customer named “Alfreds Futterkiste” from the “Customers” table.

Answer 4

DELETE FROM Customers 
WHERE CustomerName = 'Alfreds Futterkiste';

Question 5

Q: How do you delete all records in a table without deleting the table itself?

Answer 5

DELETE FROM table_name;

Question 6

Q: Write a query to delete all rows from the “Customers” table without removing the table structure.

Answer 6

DELETE FROM Customers;

Question 7

Q: How do you delete a table entirely from the database?

Answer 7

A: Use the DROP TABLE statement.

Question 8

Q: Write an example query to delete the “Customers” table completely.

Answer 8

DROP TABLE Customers;