What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 20465 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / sanjay keserwani
we can go upto some number of records through delete while
in truncate we have to unoccupied all records.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
How do I add a primary key to a table?
what is timestamp in mysql? : Sql dba
How to start the command-line sql*plus?
Where not exists in sql?
what are the differences between binary and varbinary? : Sql dba
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
explain what is mysql? : Sql dba
how many triggers are allowed in mysql table? : Sql dba
Does inner join return duplicate rows?
Does pl/sql support create command?
Is sql a case sensitive language?
who introduced sql?
What is the use of non clustered index?
How do I remove sql developer from windows 10?
What are inner and outer joins examples of both?
