Question

Zack is working in a database named SPORT, in which he has created a table named “Sports” containing columns SportId, SportName, no_of_players, and category.

After creating the table, he realized that the attribute, category has to be deleted from the table and a new attribute TypeSport of data type string has to be added. This attribute TypeSport cannot be left blank. Help Zack write the commands to complete both the tasks.

Answer 1

To delete the attribute, category:

ALTER TABLE Sports
DROP category;

To add the attribute, TypeSport

ALTER TABLE Sports
ADD TypeSport char(10) NOT NULL;