Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11445 Views
- Fidelity, I also Faced
- E-Mail Answers
Answer Posted / pooja
The DELETE statement is used to delete rows in a table.
Syntax:
DELETE FROM table_name
WHERE some_column=some_value
e.g.
DELETE FROM Persons
WHERE LastName='Tjessem' AND FirstName='Jakob'
Truncate:-
What if we only want to delete the data inside the table,
and not the table itself?
Then, use the TRUNCATE TABLE statement:
Syntax:
TRUNCATE TABLE table_name
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
sparse lookup and where its options we find in OCI and db2?
What is a driver in database?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
What is Data Modelling?
can we delete autodiff back up that we have set through sql server agent.
What do you mean by cluster and non cluster index?
Explain buffer manager?
What is the use of default key?
How to shrink a database?
how can you perform lookup range in lookup stage expalin in detail?
What is the best database?
What is database collection?
Write a query to get maximum and second maximum in oracle?
what is rcp,if rcp disabled what happen?
What is database client?
