difference between truncate, delete aur drop?
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 to download and install sql server 2005 books online?
What is the native system stored procedure to execute a command against all databases?
What are the filtered indexes?
What have included columns when we talk about sql server indexing?
Which data type can be used only on OUTPUT parameters of the stored proceduer?
what is a cursor and what is its use?
How to generate random numbers with the rand() function in ms sql server?
Why people hate cursor?
How many types of Joins in SQL Server 2005?
9 Answers CarrizalSoft Technologies, HCL,
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
I am learning Testing, so i want to learn SQL also because SQL is important for Testing. I want to know which is best Institute in Ameerpet or SR Nagar or any other place in Hyd? Please help me.
what stored procedure would you use to view lock information? : Sql server administration