Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE & DELETE?
- 16 Answers
- 46366 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / rr
delete command delete the rows from table record by record but truncate removes all the records is nothing but it drops the table and creates table structure as it is
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does (+) mean in sql joins?
What is cursor status?
What is cascade in sql?
What is Materialized View? In What Scenario we Use Materialized View?
Why partition by is used in sql?
How insert into statements in sql?
Which data dictionary views have the information on the triggers that are available in the database?
how to use 'mysql' to run sql statements? : Sql dba
Does truncate table reset auto increment?
what is sql in mysql? : Sql dba
How to select all records from the table?
What are the query optimization techniques?
What is cursor in pl sql?
How to run pl sql program in mysql?
What is a ddl command?
