Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between Drop and Truncate
- 20 Answers
- 37204 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 indexed views and partitioned view with their syntax.
What is indexed view? How to create it?
Explain the concept of view and Types of views in SQL server?
Which sql server table is used to hold the stored procedure script?
How to define output parameters in stored procedures?
What is the difference between rank and dense_rank?
What is the difference between index seek vs. Index scan?
List some advantages and disadvantages of stored procedure?
What are the character string functions supported by sql server 2005?
Can sql servers link to other servers like oracle?
What are number line correlation administrators will use while working with a subquery?
What is the server name in sql server?
Do you know what is openxml in sql server?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is analysis service repository?
