Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37793 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
What is indexed view?
What is the difference between migration and upgradation in sql server?
How are the unique and primary key constraints different?
How do I view a stored procedure in sql server query?
What is an identity?
Can you explain about buffer cash and log cache in sql server?
What is sql server query analyzer?
How to connect to a sql server using odbc_connect()?
What is factless fact table? : sql server analysis services, ssas
You want to use a perspective in an mdx query. How do you select the perspective?
What is cdc in sql server?
Write an sql query to find first weekday of the month?
How you can get a list of all the table constraints in a database?
What are information schema views?
Do you know sql server 2008 introduces automatic auditing?
