Answer Posted / muralipitti
Delete - temparaly delete the table we can undo it using
rollback where as
truncate= delete+commit we can't rollback it .
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
how to shutdown mysql server? : Sql dba
What are the two virtual tables available at the time of database trigger execution?
What does sign mean sql?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What are the types of dbms?
what is a join? : Sql dba
What is difference between cursor and trigger?
How does sql profiler work?
What is dense_rank?
What does pl sql developer do?
Why do we use subquery?
what are the advantages and disadvantages of views in a database? : Sql dba
Is truncate ddl or dml?
how to analyze tables with 'mysqlcheck'? : Sql dba