Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11779 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 are the advantages of using database?
What is a Transformation?
What is ole db provider for sql server?
A lowest level of security by most RDBMS is
What is the difference between oracle and MS Access?
What is ole db in ssis?
What are indexes in oracle?
Can you tell any two advantages of stored procedures?
What is the purpose of TNS?
What is difference between data and database?
What is global database name?
Explain the table term used in database.
Explain natural key?
What does specialization in DBMS mean?
How many types of normalization? What is the use of it?
