+ 1
What is Difference between drop and delete in SQL?
drop and delete
4 odpowiedzi
+ 3
drop is a ddl(data definition language)operation while delete is a dml(data manipulation language)operation.
Drop deletes the table or schema from database.
Delete removes the rows from the table usually according to a where clause but not necessarily, still the schema exists for that table.
+ 3
Drop removes tha table from the database while delete only removes the data from table
+ 2
Drop is used for deleting objects like table or database.
Delete is used for deleting data from a table.
+ 2
thanks buddy #uran