Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37632 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / pavan
Drop will delete all the existing structure. if it applies
to a table, Truncate will delete only the data while
keeping the structure of the table as it is.
| Is This Answer Correct ? | 72 Yes | 3 No |
Post New Answer View All Answers
What is recompile sql server?
What are the different types of normalization?
Write a sql query to sort on different column name according to the parameters passed in the function?
please differentiate between delete and truncate?
Can sql server 2016 run on windows 7?
Explain candidate key, alternate key, and composite key?
What guidelines should be followed to help minimize deadlocks?
Why Master database is required?
Do you know what is replace and stuff function in sql server?
How to see the event list of an existing trigger using sys.trigger_events?
Where in ms sql server is ’100’ equal to ‘0’?
What is the optimization being performed in oracle and SQL Server?
What is the fillfactor concept in indexes?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How to verify a login name with sqlcmd tool?
