Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37792 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / suman kalyan betal
DROP means it's drop the table(with rows,Pk_key, Fk_key and
indexces)from the database.
TRUNCATE do the same as DROP but maintain the Pk_key,
Fk_key and indexces declaration only remove rows.
---by suman kalyan betal (suman_kal@rediffmail.com)
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Differentiate sql server reporting services vs. Crystal reports?
How the authentication mode can be changed?
What functions can a view be used to performed?
Explain table valued parameters in sql server? Why tvp used?
How do I find the sql server database version?
What is the order in which the sql query is executed?
Explain a join?
what is memory-optimized nonclustered indexes
What are the aggregate and scalar functions?
What are the elements of dbms?
What is spatial and temporal data?
What is the difference between stored procedure and functions?
Is sql server 2016 free?
How to provide values to stored procedure parameters in ms sql server?
