what is the difference between delete and truncate?
Answer Posted / kumarsunny9
Truncate is more faster than delete.
in sql you need to write statement: truncate table
table_name
truncate delete all record from table.it remain only
structure of table.
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is database management system(dbms)?
What is a 3nf table?
What is the purpose of queries in a database?
What is rdms?
In which format data is stored in database?
Explain the architecture of reporting services?
Is google scholar a database?
What entity means?
What is a form used for in a database?
What are collection pools? What are the advantages?
What is an optimization and performance tuning and how does it really work in practical projects?
What is etl process in data warehousing? What are the different stages in 'data warehousing'?
What is a Federated Query ?
What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?
Can we save image in database?