What is the difference between Drop and Truncate
Answer Posted / arjun tailor
drop command will delete the entire row also the structure
but truncate will delete the contents only not the
structure.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is trigger in salesforce?
How to rebuild the master database?
explain different types of cursors? : Sql server database administration
Explain user defined functions?
What is sql sandbox in sql server?
Explain DBCC?
How to concatenate two binary strings together?
How to enable tcp/ip protocol on a sql server?
What are the indexes in sql server?
Can another user execute your local temporary stored procedures?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How can you ensure that the database and sql server based application perform well?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
Tell me what is normalization? Explain different forms of normalization?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions