Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE and TRUNCATE?
- 15 Answers
- 25122 Views
- Johns Hopkins University, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / raam
Delete command will remove the data values ( all the
records of table) and space and table structure will be
ramain. We cannot free the space and remove the table
structure using Delete command.
Truncate command will free the memory and removes table
structure from data dictionary.
ramumcato@yahoo.com
| Is This Answer Correct ? | 9 Yes | 11 No |
Post New Answer View All Answers
What is data abstraction in sql?
What are the types pl/sql code blocks?
What port does sql server use?
Why we use joins in sql?
Why do we use partitions in sql?
what is a unique key ? : Sql dba
What is pl sql block structure?
What is rownum?
Can we use threading in pl/sql?
Explain the difference in execution of triggers and stored procedures?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
how to create a table index in mysql? : Sql dba
When is the explicit cursor used ?
Why left join is used in sql?
What is the purpose of the sql select top clause?
