Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37876 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
Explain about sql server login?
Explain the third normal form(3nf)?
What is sql view?
what does the automatic recovery do? : Sql server administration
Explain the collation?
How to create a user to access a database in ms sql server using "create user" statements?
How would you use user_constraints table in DB?
How do you delete a trigger?
How to replace null values in expressions using isnull()?
What is the log shipping?
What are the advantages of using cte?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Is it safe to delete log files?
How to restore performance issues and how to check?
Explain use of expression builder.
