Interested to Buy Any Domain ? << Click Here >> for more details...
difference between truncate, delete aur drop?
- 2 Answers
- 5337 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 |
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.
Is port 1433 secure?
What is the difference function and stored procedure?
Write a sql query to sort on different column name according to the parameters passed in the function?
Distinguish between commit and rollback?
List out the differences between global and local temp tables in sql server?
is there a column to which a default can't be bound? : Sql server database administration
Can binary strings be used in arithmetical operations?
How to disable triggers using "disable trigger"?
Explain the difference between cross join and full outer join?
How to drop existing indexes in ms sql server?
-
Oracle (3253) - 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)
