What is the difference between delete and drop ?

Java Object oriented programming

45 followers study24x7

28 Jul 2021 12:03 PM study24x7

What is the difference between delete and drop ?

Web Development

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;

Reply 28 Jul 2021 12:07 PM