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 sql difficult?
Which is faster count (*) or count 1?
how to convert dates to character strings? : Sql dba
Is sql database free?
What is the use of procedures?
Can there be 2 primary keys in a table?
What are the benefits of triggers?
What will you get by the cursor attribute sql%rowcount?
What is the difference between an inner and outer join?
What are views in sql?
What is normalization? How many normalization forms are there?
What is sql key?
Which sorts rows in sql?
What is a nested table in word?
What is a sql*loader control file?