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
what is acid property in database? : Sql dba
What is the use of sqlerrd 3?
How many types of indexes are there in sql?
How subquery works in sql?
What is bitemporal narrowing?
Which certification is best for sql?
How do you update f as m and m as f from the below table testtable?
What are analytical functions in sql?
what are date and time data types in mysql? : Sql dba
What is sqlservr exe?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What are the different type of joins in sql?
what is a table in a database ? : Sql dba
What is pls_integer in pl sql?
What are the different set operators available in sql?