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 function and procedure?
What is sap sql?
How many indexes can be created on a table in sql?
Why is a primary key important?
What are the indexing methods?
Is sql a backend?
Where is pl sql used?
What is a sql*loader control file?
List and explain the different types of join clauses supported in ansi-standard sql?
tell us something about heap tables. : Sql dba
What is a rank in sql?
Can we insert in sql function?
What are different types of keys?
What is dense_rank in sql?
What is the difference between partition and index?
