Answer Posted / shankar
DELETE and TRUNCATE both delete table from database, but
DELETE - temperorily deletes the table so we can undo the
table.
TRUNCATE - Perminently delete the table from database so we
cant undo it.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
Is truncate ddl or dml?
What is on delete restrict?
How are functions and procedures called in PL/SQL?
What is join view in sql?
What is sql injection vulnerability?
Which is better join or subquery?
What are the two types of cursors in pl sql?
explain the difference between bool, tinyint and bit. : Sql dba
What is offset and limit in sql?
Is stored procedure faster than query?
What do you understand by case manipulation functions?
How do I create a sql database?
What are the indexing methods?
What is the basic structure of an sql?
What is user in sql?