To add a NULL column to a table,we ________.
A)use the REVISE TABLE command
B)use the ALTER TABLE command
C)use the MODIFY TABLE command
D)create a new table with the NULL column,move the other data,and drop the old table

Question

Quizplus · Accepted Answer

To add a NULL column to a table, we use the ALTER TABLE command. The ALTER TABLE command allows us to modify the structure of an existing table. Specifically, we can use the ADD COLUMN clause followed by the name and data type of the new column. In this case, we can also specify that the column allows NULL values by not assigning a default value. For example:

```
ALTER TABLE mytable
ADD mycolumn VARCHAR(50) NULL;
```

To Add a NULL Column to a Table,we ________