DELETE an DROP

Discussion in 'Databases' started by seotomcthomas, Jul 18, 2012.

0
  1. #1
    What is the differents between DELETE and DROP command in data base...?
     
    seotomcthomas, Jul 18, 2012 IP
  2. Suu

    Suu Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Hay,

    If you run a delete command on any table it will delete the data from the table. But the table will remain there. When you will run a select a query on the same table it will show the table with no rows.

    If you run a drop on the table it will drop the table from the database. And if you run a select on the table it will show you no table exist.

    Moreover, if you have run a delete on a table it can be rollbacked means you can get the data back. But of you run a drop, it can not be rollbacked.
     
    Suu, Jul 19, 2012 IP
  3. HostPlanz

    HostPlanz Well-Known Member

    Messages:
    449
    Likes Received:
    34
    Best Answers:
    4
    Trophy Points:
    130
    #3
    DELETE is used to remove a row(s) from a table whereby DROP removes a table from the database.
     
    HostPlanz, Jul 19, 2012 IP