hi, everybody !
how to different between drop table and truncate table ?
thank you.
Hi,
I think you want the difference between DELETE tables and TRUNCATE table. Right?
1. Both will be used to delete rows from the table.
2. TRUNCATE will delete all the rows from the table. Because we cant
use "WHERE" clause in truncate statement.
3. We can rollback the records which are deleted by "DELETE" commands.
But We cant rollback the deleted records, if you deleted by
using "TRUNCATE" commands.
4. DELETE is DDL statement. But TRINCATE is DML statement
Thanks,
Srinivas r.