Computer Science
Differentiate between DROP TABLE, DROP DATABASE.
DDL & DML
5 Likes
Answer
| DROP TABLE | DROP DATABASE |
|---|---|
| This command is used to delete a specific table from the database along with all its data, indexes, triggers, and constraints. | This command is used to delete an entire database including all its tables, views, stored procedures, triggers, and other objects. |
The syntax is : DROP TABLE table_name;. | The syntax is : DROP DATABASE database_name;. |
Answered By
4 Likes
Related Questions
What are table constraints ? What are column constraints ? How are these two different ?
What is default value ? How do you define it ? What is the default value of column for which no default value is define ?
Differentiate between DROP TABLE, DROP clause of ALTER TABLE.
Insert all those records of table Accounts into table Pending where amt_outstanding is more than 10000.