Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37820 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
How use inner join in sql server?
What is instead of trigger sql server?
How many types of triggers are there?
What is implicit mode in sql server?
What are transactions in sql?
How do I start sql server?
What does select 1 mean?
What is collation?
Why do you want to join software field as you have done your BE in Electronics?
Write a SQL query to make a column as unique?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
How many clustered indexes there can be on table ?
Can you force a query to use a specific index?
Explain indexed views and partitioned view with their syntax.
