What is difference between TRUNCATE & DELETE?
- 16 Answers
- 39771 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
Can unique keys be null?
What is a field in a database?
Which data type is a composite type?
Define sql delete statement.
What is a table in a database?
What is a memo field?
What is sql*loader?
What is set serveroutput on in pl sql?
How can we avoid duplicating records in a query?
how does a local variable is defined using t-sql? : Transact sql
What are the advantages of stored procedure?
What is a recursive stored procedure?
What is cursor explain with example?
Explain the select statement in sql?
what is the difference between group by and order by in sql? : Sql dba
