Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37879 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 acid properties? : Sql server database administration
What is the cartesian product of table?
What is master database? : SQL Server Architecture
Can we install sql server 2016 on windows 7?
What security features are available for stored procedure?
What is a data collection table?
What is after dml trigger?
What are the five major components of a dbms?
How to return the date part only from a sql server datetime datatype?
What is difference between line feed ( ) and carriage return ( )?
what is checksum in sql server.........???
What are the differences between stored procedure and the dynamic sql?
What is triggers and its types?
What is the default port for SQL Server over a firewall?
If the job running very slow what is the action you do
