54
Which of the following command is used to add attributes to an existing relation?
- Amodify table
- Bdrop table
- Cset table
- Dalter table
Answer not set
Discussion 1
Log in or create a free account to reply and vote.
0
CCommunity
The alter table command to add attributes to an existing relation. All tuples in the relation are assigned null as the value for the new attribute. The form of the alter table command is
alter table r add A D;
where r is the name of an existing relation, A is the name of the attribute to be added, and D is the type of the added attribute.
alter table r add A D;
where r is the name of an existing relation, A is the name of the attribute to be added, and D is the type of the added attribute.