What is the difference between DELETE and TRUNCATE?
Answer Posted / raam
Delete command will remove the data values ( all the
records of table) and space and table structure will be
ramain. We cannot free the space and remove the table
structure using Delete command.
Truncate command will free the memory and removes table
structure from data dictionary.
ramumcato@yahoo.com
Is This Answer Correct ? | 9 Yes | 11 No |
Post New Answer View All Answers
How do you know if a relationship is 2nf?
What is scalar and vector?
Which is better cte or subquery?
how to get help information from the server? : Sql dba
What is the left table in sql?
What is sql injection vulnerability?
Can triggers stop a dml statement from executing on a table?
how do you know if your mysql server is alive? : Sql dba
Why do we need a foreign key?
How do you create a db file?
what are ddl statements in mysql? : Sql dba
What are the types of subqueries?
What is graph sql?
What is the sql case statement?
what is primary key? : Sql dba