Interested to Buy Any Domain ? << Click Here >> for more details...
Can you tell me the difference between DELETE & TRUNCATE
commands?
- 15 Answers
- 24965 Views
- I also Faced
- E-Mail Answers
Answer Posted / amita
Delete command only delete the rows from the table but the
schema of the table yet remains.Whereas Truncate command
delete the rows along with the tale's schema from the
memory permanently.
| Is This Answer Correct ? | 3 Yes | 28 No |
Post New Answer View All Answers
What are temporal tables in sql server 2016?
Where in ms sql server is ’100’ equal to ‘0’?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Can we add an identity column to decimal datatype?
How to add a new dsn with the odbc driver for sql server?
Explain try...catch with sql server?
What are the difficulties faced in cube development? : sql server analysis services, ssas
How to get a list of columns in a view using the "sp_help" stored procedure?
What is the name of reporting services config file and what’s it’s used for?
What stored procedure would you use to view lock information?
What are the advantages of user-defined functions over stored procedures in sql server?
Do you know what is lock escalation?
How to create median function?
what is a check constraint?
How do you rename a table in sql server?
