Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25176 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / anitha
If we are using the delete command means the content of the
table will be deleted.but we can recover that data by using
the roll back query in my sql.
But this one is not possible we can use truncate.so some
times of our carelessness we can loss some valuable and
sensitive datas.
so make sure of that before using truncate...
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is tuple in sql?
What is sqlcommand?
Is inner join same as self join?
Explain the uses of database trigger.
What view means?
How global cursor can be declare with dynamic trigger ?
What program will open a mdb file?
What are procedures used for?
How do I run a sql script?
How does postgresql compare to oracle/db2/ms sql server/informix?
What is a trigger in sql?
How many types of index are there?
What is the maximum rows in csv?
Are null values same as that of zero or a blank space?
What are inbuilt functions in sql?
