Oracle DROP and TRUNCATE table (DDL Commands) | Oracle SQL fundamentals
DROP and TRUNCATE are #DDL commands, whereas #DELETE is a #DML command. DELETE operations can be rolled back (undone), while DROP and TRUNCATE #operations cannot be rolled back.
Use the #DROP TABLE statement to move a table or object table to the recycle bin or to remove the #table and all its data from the database entirely.
#TRUNCATE command removes all the records from a table. But this command will not destroy the table's structure. When we use TRUNCATE command on a table its (auto-increment) primary #key is also initialized.
Website: https://www.dbagenesis.com/
Facebook: / dbagenesis
Instagram: / dbagenesis
Twitter: / dbagenesis