Interested to Buy Any Domain ? << Click Here >> for more details...
difference between truncate, delete aur drop?
- 2 Answers
- 5240 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 |
does physical index sort data
What is table value parameters (tvp)?
How to execute a stored procedure in ms sql server?
What is sub query and its properties?
How do indexes help, types?
Can we use where and having clause together?
How to check parameter value in stored procedure sql server?
What is the security principal at the server level that represents your session?
Explain different types of lock modes in sql server 2000?
How do I list the available tables in a database I'm querying?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
Can group by and orderby be used together?
-
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)
