Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37258 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / suman kalyan betal
DROP means it's drop the table(with rows,Pk_key, Fk_key and
indexces)from the database.
TRUNCATE do the same as DROP but maintain the Pk_key,
Fk_key and indexces declaration only remove rows.
---by suman kalyan betal (suman_kal@rediffmail.com)
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is model database? : SQL Server Architecture
What is an execution plan?
What is the command used to recompile the stored procedure at run time?
How to insert a new row into a table with "insert into" statements in ms sql server?
Explain datetime2 data type in sal server 2008?
What is cursors?
How do I start sql server 2017?
What is a primary index?
What are entities and relationships?
Can group by and orderby be used together?
What is tablix?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
How many partitions a clustered index has by default in sql server 2012?
What are the different types of sql server replication? : sql server replication
What is dbcc command in sql server?
