difference between truncate, delete aur drop?
- 2 Answers
- 4460 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / v.krishnakumar
in truncate we can delete inside the table data not the
structure of the table,in delete operation we can remove
our data in the table as well as structure but we can get
again using rollback operation, in drop operation it was
permanentely removed from our database we cannot get agian.
| Is This Answer Correct ? | 13 Yes | 2 No |
truncate are the use to the remove the data as well all the space into the table , and the delete are use to the delete only for the data into the table,and the drop is use to the delete or remove the table....
| Is This Answer Correct ? | 5 Yes | 1 No |
explain different types of backups avaialabe in sql server? : Sql server database administration
What is a raid and what are different types of raid configurations?
Explain candidate key, alternate key, and composite key?
How to get the definition of a trigger back?
What is store procedure? How do they work? When do you use?
How to get last system shutdown time in Sql server when restarted system?
What is tempdb database? : SQL Server Architecture
What is side by side migration in sql server?
How to create an identity column?
What are the components of dbms?
What is default port number for sql server 2000?
what is a self join? : Sql server database administration
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
