Pages

Friday 11 January 2013

Differnece between Delete and Drop

Delete Command will delete all the data but table structure will still exists.But if you want to remove entire table then you can use the drop table command.When a table is dropped, it no longer exists; its definition or structure is removed from the database. 
 
Delete from tablename
Drop Table tablename

No comments:

Post a Comment