What is the difference between Drop and Truncate
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
Define Business Edition in SQL Azure?
Do you know how to store and query spatial data?
Relational calculus is what type of language?
What is the difference between clustered index and primary key?
What is partitioned view?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
How to set database to be read_only in ms sql server?
Can a unique index be created on a column, which contains null?
Mention the different types of triggers?
How to change the ownership of a schema in ms sql server?
how can you check the level of fragmentation on a table? : Sql server administration
Explain about merge replications?
Explain “not null constraint” in sql server?
What are the purpose of Normalisation?
What is a partition function in sql server?