| September 09, 2009 01:00:59 |
#7 |
| surya72446 |
Member Since: September 2009 Total Comments: 2 |
How many ways you can delete the table records ?
|
Actually there are three ways to delete a table
1. Delete: This is used to delete the one or all the records. The thing with this is that only data is been deleted but the table structure and the memory allocated to it is safe.
2. Truncate: Truncate is similar to Delete, the only difference is that it keeps the structure but removes the memory allocated to the table.
3. Drop: This is used to delete the entire table along with the table structure and memory allocated to it. |
| |
