Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37647 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / satyanarayana
Drop and Truncate commands both are DML commands.
If we use drop command it will deletes all the table data
as well as tablestructure.But if we use truncate command it
will deletes the table data only.
| Is This Answer Correct ? | 24 Yes | 44 No |
Post New Answer View All Answers
How to rename an existing column with sql server management studio?
Tell me in brief how sql server enhances scalability of the database system?
What is PROJECTION Operation?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What are the disadvantages of using querystrings to send data from one page to another?
How will you add a dimension to cube? : sql server analysis services, ssas
How do you know if sql server is running on your local system?
How are the exceptions handled in sql server programming?
What is unique key constraint?
Explain how to maintain a fill factor in existing indexes?
How to find related tables in sql server?
How will you decide the active and passive nodes?
Can the query output be sorted by multiple columns in ms sql server?
How to loop through result set objects using odbc_fetch_row()?
Explain the categories of stored procedure?
