Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37612 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
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
What are the advantages of mirroring?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
Characterize join and name diverse sorts of joins?
What is the definition for sql server 2000?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
Find columns used in stored procedure?
What are secondary xml indexes?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is normalization? Explain its different types?
what are the different types of SSRS reports?
You want to implement the many-to-many relationship while designing tables. How would you do it?
Can binary strings be converted into numeric or float data types?
What is not null constraint?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
what is the difference between a primary key and a unique key? : Sql server database administration
