filmov
tv
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.
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.