Answer Posted / joe
Delete is DML and truncate is DDl;
both or used to delete the records from the table.
We can rollback the deleted records but we cant when we used truncate.
Delete is faster than truncate
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What are aggregate and scalar functions?
what are myisam tables? : Sql dba
What operators deal with null?
What is a sql instance vs database?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What is the use of sqlerrd 3?
what is a database lock ? : Sql dba
What is a primary key sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Can a select statement fire a trigger?
How many sql statements are used?
what does the t-sql command ident_current does? : Transact sql
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
What is crud diagram?
What are the three pl sql block types?
