Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE & DELETE?
- 16 Answers
- 44950 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
Truncate Delete
1)it is DDl command it is DML command
2)it delete records permanently it delete records temporarly
we can't roll back we can roll back the data
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how many tables will create when we create table, what are they? : Sql dba
What are two statement types in sql?
How do you rename a table in sql?
Which is better trigger or stored procedure?
Explain the difference in execution of triggers and stored procedures?
What is a field in a database?
Which tcp/ip port does sql server run?
How do I truncate a word?
What is latest version of sql?
does sql support programming? : Sql dba
Can we use commit inside a trigger?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
what are all types of user defined functions? : Sql dba
Can we join tables without foreign key?
what is cross join? : Sql dba
