What is the difference between delete and drop ? - Study24x7
Social learning Network

Warning: include(./views/auth.php): failed to open stream: Permission denied in /var/www/html/live/loginRightSlider.php on line 18

Warning: include(): Failed opening './views/auth.php' for inclusion (include_path='.:/usr/share/php') in /var/www/html/live/loginRightSlider.php on line 18
Java Object oriented programming
47 followers study24x7 01 Jan 1970 05:30 AM study24x7 study24x7

What is the difference between delete and drop ?

Web Development
Like | 1 Comment | 1 Share
study24x7
Write a comment
  • Edubabble LLP
    • DELETE is a Data Manipulation Language (DML) command and used when you want to remove some or all the tuples from a relation. If WHERE clause is used along with the DELETE command it removes only those tuples which satisfy the WHERE clause condition but if WHERE clause is missing from the DELETE statement then by default all the tuples present in relation are removed. The syntax of DELETE command: DELETE FROM relation_name WHERE condition; DROP is a Data Definition Language (DDL) command which removes the named elements of the schema like relations, domains or constraints and you can also remove an entire schema using DROP command. The syntax of DROP command: DROP SCHEMA schema_name RESTRICT; DROP Table table_name CASCADE;

    See more

    Like
    Reply 01 Jan 1970 05:30 AM
    Related Questions
    500+   more Questions to answer

    Get the App

    Download the Study24x7 App, so you can connect and collaborate.

    study24x7
    study24x7
    Most Related Articles