SQL DROP TABLE

Sometimes we may decide that we need to get rid of a table in the database for some reason. In fact, it would be problematic if we cannot do so because this could create a maintenance nightmare for the DBAs. Fortunately, SQL allows us to do it, as we can use the DROP TABLE command. The syntax for DROP TABLE is

 

 

So, if we wanted to drop the table called a customer that we created in the last section, we simply type

DROP TABLE customer.