Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE & DELETE?
- 16 Answers
- 44949 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / suneel
truncate:
---------
truncate is a ddl command.
ddl commands having auto commit.
delete:
-------
delete is a dml command.
dml commands not having auto commit.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
how many ways we can we find the current date using mysql? : Sql dba
What is data profiling in sql?
What is the maximum number of triggers, you can apply on a single table?
what are rollup and cube in t-sql? : Transact sql
What is meant by truncate in sql?
How do you sort in sql?
What is rtm in testing?
Can a varchar be a primary key?
What do you understand by exception handling in pl/sql?
What is #table in sql?
What is a table partition?
Are views faster than queries?
Which are the different types of indexes in sql?
What are different types of sql commands?
