Get Started: SQL DROP TABLE Statement

In This Article, You Will Know About SQL DROP TABLE Statement. 

Before moving ahead, let’s know a bit about the SQL DROP TABLE Statement.

Table of Contents

SQL DROP TABLE Statement

In SQL, the DROP TABLE statement is used to delete the existing table from the database.

Syntax

				
					DROP TABLE table_name;
				
			

Example: Use DROP TABLE statement to delete a table called “Student_Information”.

				
					DROP TABLE Student_Inforfmation;
				
			

Note: DROP TABLE statement will delete the whole table completely.

SQL TRUNCATE TABLE

In SQL, TRUNCATE TABLE statement is used to delete the only data instead of the table.

Syntax

				
					TRUNCATE TABLE table_name;
				
			

Example: Use TRUNCATE TABLE statement to delete only the table’s data called “Student_Information”.

				
					TRUNCATE TABLE Student_Inforfmation;
				
			

If you find anything incorrect in the above-discussed topic and have further questions, please comment below.

Connect on:

1 thought on “Get Started: SQL DROP TABLE Statement”

Leave a Comment

Stay in the loop

codingstreets