What is the difference between Drop and Truncate
- 20 Answers
- 34457 Views
- GT Nexus, IBM, I also Faced
- E-Mail Answers
Answer Posted / vishant kakwani
drop is delete the data with table and if id is used as autoincrement then id can't be started with 1.
Truncate is delete the only data table as it is and autoincrement id will started with 1 every time if you truncate the table.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are the types of joins in sql?
What do you mean by table and field in sql?
Explain stored procedure?
How to rename an existing column with sql server management studio?
what are defaults? : Sql server database administration
How to set a database state to offline in ms sql server?
What is schemabinding a view?
What is a file group?
What is difference between join and natural join?
How to specify the collation for a character data type in ms sql server?
What are different types of replication in sql server?
Can a table have 2 foreign keys?
Explain query editor regions
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is inline variable assignment?
