Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37196 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / lakshmi
Drop can be used to drop the entire table including data
and structure of table where as truncate removes rows from
table but the structure of table remains as it is.
| Is This Answer Correct ? | 18 Yes | 1 No |
Post New Answer View All Answers
What is difference between rownum and row_number?
Explain sql server authentication modes?
What are various aggregate functions that are available?
How to perform key word search in tables?
When we should use @@error?
Can we check locks in database? If so, how can we do this lock check?
What are the commands used in DCL?
Can you always create a cache of a report?
What is difference between equi join and inner join?
What are the different normalization forms?
What are the types of user defined functions in sql server?
How to copy the tables, schema and views from one sql server to another?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
How many types of schemas are there?
What number sorts of privileges are accessible in sql?
