function truncate

[khanhly]

hi, everybody !

how to different between drop table and truncate table ?

thank you.

[frozenmist]

Hi,
What a drop table is does is, it functions as a table delete i.e; it ceases to exist in the data base.
Whereas the truncate deletes all rows from the table.
Is this enough?

Cheers

[rsrinivasan]

hi, everybody !

how to different between drop table and truncate table ?

thank you.

Hi,
I think you 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.

[rsrinivasan]

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.

[sushjames]

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.

can anyone tell me how to recall the deleted data ?

[rsrinivasan]

can anyone tell me how to recall the deleted data ?

Hi,
Just use "ROLLBACK" command.

Thanks,
Srinivas r.