SQL Server Delete Table

you can delete table from SQL server in two ways, using SQL server Management studio or by using script.

Delete table SQL server Management studio.

1)Go to SQL server management studio, select database.

2)Open tables,select tables.

3)Right click on the table , you will get a  context menu. 

4)Choose delete table. New interface will be open to inform you that you are going to delete the table object . 

5)Click on "Ok". Your table will be deleted



Delete table by using script.

You can delete table by using script also. 

DROP TABLE table name 

is the syntax of the same. Now execute the query .Table will be deleted and you will get and confirmation message also.

 

DROP TABLE student