Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37610 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
What is the difference between varchar and varchar types?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is relationship? What number of sorts of relationship are there?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What is it’s similarity with sql server?
Explain steps of normalization?
What is function of ROLLUP ?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
Explain about local stored procedure?
What is an expensive query?
What is PROJECTION Operation?
How self join is different from outer join?
How to create an multi-statement table-valued function?
What are the database objects? : SQL Server Architecture
What area unit the various kinds of info compression introduced in sql server 2008?
