Introduction:

In this article we will explain how to delete a table in SQL server database or how to drop a table in SQL server database with example.

Description:

In SQL Server DROP TABLE statement is used to delete a table with definition and data from the Database.This is very important to know that once a table is deleted all the information available in the table is lost forever, so we have to be very careful when using this command.

Let's see the syntax to drop the table from the database.

DROP TABLE "table_name"

Let us take an example to delete customer table:

DROP TABLE Customer;

I hope this article will help to you.

0 comments


Leave a comment

Make sure you enter the (*) required information where indicated. HTML code is not allowed.

You may also like