Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37818 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / pavan
Drop will delete all the existing structure. if it applies
to a table, Truncate will delete only the data while
keeping the structure of the table as it is.
| Is This Answer Correct ? | 72 Yes | 3 No |
Post New Answer View All Answers
Why would you use sql agent?
What will happen if a column containing char type data is changed to the nchar data type?
What is bcp? When does it used?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What is the difference between char, varchar and nvarchar?
how would you improve etl (extract, transform, load) throughput?
What is 1nf 2nf and 3nf?
Do you know how to store and query spatial data?
What is a view and what are its advantages?
Explain what are the events recorded in a transaction log?
What is a partition key?
State the difference between union and union all?
Tell me what is the difference between locking and multi-versioning?
What are ddl (data definition language) statements for tables in ms sql server?
What is table join?
