Software Testing

k2G9Eo9
RdZQRt6

Popular Posts

DROP

The DROP command removes a table from the database. All the tables' rows, indexes, and privileges will also be removed. No DML triggers will be fired. The operation cannot be rolled back.
If we want To Remove Database forever we can use DROP Command.
Basic Syntax:
DROP DATABASE DB_Name
If we want to Remove a Table forever from the database we can use DROP Command.
DROP TABLE Table_Name
To Remove any Column from existing table
ALTER TABLE Employee DROP COLUMN Dept_id
After Execute: 
Command(s) completed successfully.

No comments:

Post a Comment