Interested to Buy Any Domain ? << Click Here >> for more details...
difference between truncate, delete aur drop?
- 2 Answers
- 5271 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 |
What are the different types of backups that exist?
Which Model uses the SET concept
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What are the different index configurations a table can have?
What is the difference between migration and upgradation in sql server?
How to enforce security in sql server? : sql server security
How connect excel to sql server?
How to transfer an existing table from one schema to another schema in ms sql server?
What are the restraints imposed on the table design by a merge replication?
What is the purpose of update statistics and scope_identity() function?
How to create a large table with random data for index testing in ms sql server?
How do you load large data to the SQL server database?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
