Friday , December 6 2024

DROP TABLE

In today’s article, we will learn how to drop an existing table in a database with the DROP TABLE command.

Tables that are connected to each other with the primary key / foreign key relationship are deleted as follows to avoid errors when deleting.

When the table is deleted, it may not disappear directly. This depends on the value of the “RECYCLEBIN” parameter.

If ON, the table is sent to the trash first. And if desired, it can be brought back with flashback in a short time.

The value of the “RECYCLEBIN” parameter can be seen as follows.

We can see the tables in the trash bin as follows.

1.

2. The trash bin of the user we are logged in to;

For all users;

The size of the deleted table is not released immediately. It must be deleted from the trash to be released.

Loading

About Onur ARDAHANLI

Leave a Reply

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