Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37850 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / ganesh mandlik
DROP :- DROP will Remove Structure as well as all the Data
of the Table.
i.e. Primary Key, Foreign Key, Indexes & etc...
Truncate :- Truncate will Remove only Data But not the
Structure of the Table.
Ganesh Mandlik......
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain stored procedure?
Do you know clustered and non-clustered index?
What are the pre-defined functions in the sql server?
What is a rollup clause?
Can a rule be bound to any column of any data type?
Who developed sql server?
How to perform backup for certificates in sql server? : sql server security
What is schemabinding a view?
how you can configure a running aggregate in SSRS?
Why people hate cursor?
role of sql sever 2005 in database rather than any other database
How retrieve field names from the table in SQL through JAVA code?
What are the recovery models for a database?
Explain identity in sql server?
What happens if the update subquery returns no rows in ms sql server?
