What is the difference between DELETE and TRUNCATE?
Answer Posted / shilpa
Delete command delets one row or whole table with table
defination but truncate command only delete table not table
defination
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the usage of sql functions?
Can we join tables without foreign key?
What is range partitioning?
What is the syntax to add a record to a table?
Explain the purpose of %type and %rowtype data types with the example?
What does desc stand for?
How are sql commands classified?
What are different types of queries in sql?
Is left join same as join?
What are conditional predicates?
Where is all the data on the internet stored?
What is dense_rank in sql?
how to rename an existing column in a table? : Sql dba
What are different types of triggers?
What are different types of indexes?