Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between delete and truncet ?
- 7 Answers
- 11743 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
A design problem was given in which I was supposed to make a design for the data base for a given problem.
How many types of locks are present in a database?
What is global database name?
How do you connect to a database?
diff b/w inter process and in process
WHAT IS CARDINALITIES OF JOIN?
What is the purpose of TNS?
Is storing images in a database a good idea?
What are different types of blocks used in stored procedure?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
What do you mean by database?
How do I manually create a database?
What is a reference table in database?
what is the full procedure for using store procedure in informatica7.1?
Display the employees whose salary is less than average salary.
