Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37908 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / antim
both are ddl commands.Drop deletes the table with schema
and records but truncate deletes only records.Drop can be
roll back but not truncate.
| Is This Answer Correct ? | 7 Yes | 9 No |
Post New Answer View All Answers
List out the different types of locks available in sql server?
What is index fragmentation in ms sql server?
Explain how many normalization forms?
How to maintain a fill factor in existing indexes?
What do you understand by physical_only option in dbcc checkdb?
What is the function of inner join?
Are null values the same as that of zero or a blank space?
How you trouble shoot when any job fails
What is a collation?
How many database files are there in sql server 2000?what are they?
What does executeupdate return?
How do you check sql server is up and running?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Can we deploy SSRS reports on our personal website?
what are the important architecture components of SSRS?
