Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37633 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / sripathi venkata ramesh
I am Sripathi Venkata Ramesh
Drop: Table structure + Data are deleted
Truncate: Data alone deleted but it is faster than delete.
Here we can not use where Condition here.
Delete: Data alone deleted. Here we can use where condition
here
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the tables in sql?
what are user defined datatypes and when you should go for them? : Sql server database administration
List the different index configurations possible for a table?
What is the use of set nocount on/off statement?
What is the tcp/ip port on which sql server runs?
What are the reporting services components?
How check triggers in sql server?
Define Wed Edition in SQL Azure?
How to check parameter value in stored procedure sql server?
Write a SQL query to make a column as unique?
How to add more data to the testing table in ms sql server?
What is Replication?
What is the query and subquery?
What are various aggregate functions that are available?
How to get nth highest salary from employee table.
