Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38441 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / madhu
drop will delete the entier table content including its
structure.
but truncate will delete the datas which in the table.
it wont save the data any where so we cannot rollback those
data.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can we check the sql server version?
Some queries related to SQL
How can we rewrite sub-queries into simple select statements or with joins?
What is 2nf in normalization?
How to check if a table is being used in sql server?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
How much does sql server 2016 cost?
What is SQL Server?
Determine when to use stored procedure to complete sql server tasks?
What is acid properties?
What is meant by indexing?
Explain how many normalization forms?
How to throw custom exception in Stored Procedure?
what information is maintained within the msdb database? : Sql server administration
