Answer Posted / v.krishnakumar
in truncate we can delete inside the table data not the
structure of the table,in delete operation we can remove
our data in the table as well as structure but we can get
again using rollback operation, in drop operation it was
permanentely removed from our database we cannot get agian.
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What are triggers? How do you invoke a trigger on demand?
What method is used by the Command classes to execute SQL statements that return single values?
What is a Join and explain its types?
What is resource governor in sql server?
Do you know what is openxml in sql server?
What is mapping schema?
How is sql server used?
What is mean by candidate key?
What do you think of this implementation? Can this be implemented better?
What is function of ROLLUP ?
What is meant by datasource?
Which is faster statement or preparedstatement?
In what three ways is the return statement used in a stored procedure?
Explain full-text indexing?
What is server-level principal?