TRUNCATE TABLE & DROP TABLE Commands in SQL || Lesson 43 || DBMS || Learning Monkey ||

TRUNCATE TABLE and DROP TABLE Commands in SQL

In this class, we will understand TRUNCATE TABLE and DROP TABLE Commands in SQL.

We have already discussed the concepts of alter table.

TRUNCATE TABLE and DROP TABLE Commands in SQL

To understand, we will use the user’s table as shown below.

In the above table, we have two rows.
TRUNCATE TABLE Command

The TRUNCATE TABLE statement deletes the data inside a table, but not the table itself.

If we want to delete all the rows in the table, we have to use the truncate command.

With the truncate, we can delete all the rows in the table, but not the table itself.

The syntax for truncate is as shown below.

TRUNCATE TABLE table_name;

Now, we will truncate the user’s table.

TRUNCATE TABLE users;

We will check whether the rows have been deleted or not by using the select command.

The table has been truncated.
DROP TABLE Command

The DROP TABLE statement is used to drop an existing table in a database.

To delete the structure of the table, we use the drop command.

The syntax to drop a table is as shown below.

DROP TABLE table_name;

DROP TABLE users;

The user’s table no more exists.

Let us check with the select command.

#learningmonkey #dbms #placements #gatecse #gatedbms #campusplacements

Link for playlists: