From the course: Oracle Database 19c: Basic SQL
Join today to access over 25,500 courses taught by industry experts.
Dropping tables
From the course: Oracle Database 19c: Basic SQL
Dropping tables
- [Narrator] Disk space is not unlimited, so, if you don't need to table any longer, you can drop it. You can drop it permanently, or you can retrieve it from the database Recycle Bin if the daily basis configured, whether Recycle Bin and the correct settings. In this video, I'll go over the basics of how to Drop Table, how to get back a table you accidentally dropped, and the kind of errors you might see when a table is not droppaable from one of several reasons. Here is the Syntax of the DROP TABLE command. You specify the name of the table, and optionally, the name of the table schema, if its not in your own schema. If other tables like using the table to be dropped for referential (mumbles) purposes, in other words, a Foreign Key Constraint. You have to add the CASCADE CONSTRAINT clause to drop the CONSTRAINT from all tables, referencing the table being dropped. Finally, you can add the PURGE key word if you want to free up space occupied by the table and disc. As you see later on…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.