How To Drop a Table in SQL Server


To create a table in SQL Server, you can read the article “How to Create a Table in SQL Server“. In this article, we will talk about two methods to drop the table.

First Method (With SSMS):

With SQL Server Management Studio, when you connect to SQL Server Instance, right-click on the table we want to delete under the database, and click Delete.

Second Method(With TSQL):

We can delete the table with the help of the following script.

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *