Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37852 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
What is logon trigger?
Define Business Edition in SQL Azure?
What is update_statistics command?
How to fetch the next row from a cursor with a "fetch" statement?
How to populate a table in sql server?
How to write a query with an inner join in ms sql server?
Why are views required in the sql server or in any other database?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Can you use order by when defining a view?
Explain comment on transactions?
Explain raiserror in sql server?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
How is foreign key related to primary key?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
In which tcp/ip port does sql server run? Can it be changed?
