Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38391 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 different types of raid levels?
What is indexing and its types?
How to Insert multiple rows with a single insert statement?
How to rebuild master databse?
What is a raid and what are different types of raid configurations?
What are binary string data types in ms sql server?
What is tablix?
Explain the microsoft sql server delete command? : SQL Server Architecture
What is index fragmentation in ms sql server?
Why can there be only one clustered index and not more than one?
What is public role in sql server?
What is SQL Azure Firewall?
What program is used to store the data source file?
What is service broker?
What is 5nf in normalization form?
