Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37193 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / ganesh mandlik
DROP :- DROP will Remove Structure as well as all the Data
of the Table.
i.e. Primary Key, Foreign Key, Indexes & etc...
Truncate :- Truncate will Remove only Data But not the
Structure of the Table.
Ganesh Mandlik......
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How do you test your database? : sql server database administration
What is the significance of master, tempdb and model databases?
What is master database? : SQL Server Architecture
What is data block and how to define data block size?
What is history table in sql server?
Explain the purpose of indexes?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
What is create command?
How to connect of datebase with sql express.?
What are the different types of sub-queries?
What is self contained sub query?
What is ms sql server triggers?
what information is maintained within the msdb database? : Sql server administration
Define outer join?
How to count duplicated values in a column in ms sql server?
