Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37300 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / vipin narwal
HI TO ALL!!!
DROP: will lead in deleting the structure of the table
along with all associated constraints like Primary
Key,Foreign Key,..etc and also deallocates the memory
allocated to the Database objects..
Truncate: Truncate like Delete deletes the data associated
with a Database Object but structure remains there i.e,
memory remains allocated,...but faster than Delete...
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do you migrate data from mssql server to azure?
Explain the types of indexes.
How sql server executes a statement with nested subqueries?
How to convert numeric expression data types using the cast() function?
What is the purpose of indexing?
What is exclusive locks?
How to enter binary string literals in ms sql server?
Explain the truncate command?
What is the difference between resultset and resultsetmetadata?
Does server sql treat char as a variable-length or fixed-length column?
Explain syntax for viewing trigger?
How to create sub reports?
How to use "begin ... End" statement structures in ms sql server?
What happens if you are trying to access a schema not owned by you?
What is row_number function?
