Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 38393 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
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
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
How do you delete a data source?
Explain what is meant by replication of database?
Different types of keys in SQL?
What are the purpose of Normalisation?
Explain atomicity?
what is the difference between Tabular and Matrix report?
How you can find out if an index is useful to the optimizer?
Can you index views?
Mention the 3 ways to get a count of the number of records in a table.
why would you call update statistics? : Sql server database administration
Why we need sql server?
How does Report Builder support Analysis Services cubes?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
Define the one-to-one relationship while designing tables.
