Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to change the ownership of a schema in ms sql server?
What Is Rdbms?
What is the data type of time?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Explain indexes disadvantages?
What is the difference between a primary key and a unique key? Are they the same?
Explain identity in sql server?
What are the common performance issues in sql server?
What are the differences between lost updates and uncommitted dependencies?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
what is an index? : Sql server database administration
What are the types of user defined functions in sql server?
What are the components of dbms?
Explain about analysis services?
How each E-R model constructs can be mapped to the relational model?
