Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE and DELETE statement
- 12 Answers
- 22938 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 can we use ConnectorJ JDBC Driver with MS SQL?
How do I start sql server 2017?
what is raid? : Sql server database administration
role of sql sever 2005 in database rather than any other database
What are the different types of lock modes in sql server 2000?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
how can you attach more than 20 ldf files in sql server
What are the difference between primary keys and foreign keys?
What do you mean by an execution plan?
How to create database with physical files specified in ms sql server?
How to delete existing rows in a table?
Explain steps of normalization?
What is key set driven?
How to get a list of all tables with "sys.tables" view in ms sql server?
What is co-related sub query?
