Interested to Buy Any Domain ? << Click Here >> for more details...
difference between truncate, delete aur drop?
- 2 Answers
- 5234 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 try...catch with sql server?
how we can store the value like that 001,003,023 etc in sql server 2005
what is the out put of below queries? a. select * from Emp where null = null; b. select * from Emp where 1=1;
Which table keeps information about stored procedures?
Which Model uses the SET concept
Determine how to use the inserted and deleted pseudo tables?
What is the difference between char, varchar and nvarchar?
how to overcome kernel isssues
hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
what is procedure in sql?
List all types of constraints in sql server?
-
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)
