Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22419 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / xyz
truncate basically clears the data from the rows of a
specified colomn.
e.g. truncate colomn_name from table_name
then this will only empty the colomn
delete is used to simpy delete anything from the table.
e.g. delete table_name
this will remove the whole table from the database.
| Is This Answer Correct ? | 9 Yes | 28 No |
Post New Answer View All Answers
How many full-text indexes can a table have?
What do you understand by coalesce in sql server?
Is a primary key unique?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Can we insert data into a view?
Explain nested trigger in sql?
How to create a new login name in ms sql server?
List all the types of user-defined functions?
What is the default fill factor value?
Which are ddl commands?
What are trace flags?
What are the difference between clustered and a non-clustered index?
What is Federation and Federation Member?
Can we write a distributed query and get some data which is located on other server and oracle database?
How do I find the sql server version?
