what is difference between delete and truncet ?
- 7 Answers
- 10393 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
Which database is best to store images?
What is a reference table in database?
What are the types of indexes that are present inside a database?
How does non-cluster index functions?
what is transaction state, buffer management, shadow paging
What are the concurrency problems a database faces?
What is a trace file?
How heap is implemented in database?
Display the employees whose salary is less than average salary.
Give the syntax of exception handling used in DBMS?
What is the difference between primary key, foreign key and candidate key?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
Under which circumstance should you create an index on a table?
What is difference between data and database?
issues involved in modeling and building data werahouses
