Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11980 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
What is database and its types?
What is redis good for?
What is the difference between primary and candidate key?
What is a Database?
Explain various types of locks in a transaction? Which is better and why?
What is the Lock Based Protocol used for?
What is the use of default key?
what is data access layer?
I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage
What is a trace file?
How do you pass parameter in stored procedure?
How do database connections work?
Explain entity ?
What is ole db provider for sql server?
Is database a hardware or software?
