Interested to Buy Any Domain ? << Click Here >> for more details...
difference between truncate, delete aur drop?
- 2 Answers
- 5259 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 is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What do you mean by normalisation?
What is an inner join?
Explain steps of normalization?
can we call functions from stored procedure in SQL Server 2005 ? How?
How can we remove orphan records from a table?
What is a Linked Server?
Write an sql query to find the names of employees start with ‘a’?
What command is used to delete a table from the database in the sql server and how?
What is SQL Server?
what is datawarehouse?
How do you clear a log file?
-
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)
