Computer Science
Answer
| DROP TABLE | DROP clause of ALTER TABLE |
|---|---|
| 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 remove a specific component of a table, such as columns, constraints, or indexes. |
The syntax is : DROP TABLE table_name; | The syntax is : ALTER TABLE table_name DROP COLUMN column_name; |
Related Questions
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 DATABASE.
Insert all those records of table Accounts into table Pending where amt_outstanding is more than 10000.
Increase salary of employee records by 10% (table employee).