What is the difference between Drop and Truncate
- 20 Answers
- 33978 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / mayur jain
Drop means removing.Removing the existence.
Truncate - there is no log maintained for the deleted
records.As when we perform delete a log is maintained a slow
process.
| Is This Answer Correct ? | 27 Yes | 13 No |
Post New Answer View All Answers
Do you know what is normalization of database? What are its benefits?
Explain the etl (extraction, transformation, and loading)?
What is user defined stored procedures?
Write a query for primary key constraint with identity key word?
Define views.
How to insert a new row into a table with "insert into" statements in ms sql server?
What is plan freezing?
What do you understand by sql server agent?
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is unique key constraint?
Can we create clustered index on composite key?
List out what other servers you can use with ssrs?
what is a schema in sql server 2005? : Sql server database administration
What is xml datatype?
Why we should not use triggers?
