1.

Differentiate between SQL commands DROP TABLE and DROP VIEW

Answer»

DROP TABLE:-

DROP TABLE statement is used to delete the table and all its data from the database entirely. The syntax for DROP TABLE is DROP TABLE ;

DROP VIEW:-

Removes an existing view from a database. DROP VIEW statement is used to remove a view or an object view from the database. The syntax for DROP VIEW is DROP VIEW ;



Discussion

No Comment Found

Related InterviewSolutions