what is difference between delete and truncet ?
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 indexes in oracle?
What is database client?
How does database replication work?
can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance
give a simple example of physical and logical data independence
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
What are database connection details?
Can you tell any two advantages of stored procedures?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
What advantages does DBMS have over traditional file systems?
Explain about ur projets on teradata???
What is the purpose of TNS?
What is database schema name?
Difference between sql and mysql?