Answer Posted / 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 |
Post New Answer View All Answers
How many columns can we include on clustered index ?
What are some examples of schemas?
What are temporal tables in sql server 2016?
What is a group function explain with an example?
What is the new security features added in sql server 2014? : sql server security
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
how many layers of tcp/ip protocol combined of? : Sql server database administration
What are user-defined functions (udfs) in sql server?
What does truncate do?
How to change server name in sql server?
what data regions are and what are the different data regions?
What the class forname () does?
Do you know the cursor optimization tips?
Explain differences between web edition and business edition?
How to replace the Query Result 'Null Value' with a text ?