Saved Bookmarks
| 1. |
Explain how to add a NOT NULL column to a table. |
|
Answer» First, add the column as NULL. Then use UPDATE to add data to every row. Finally use an ALTER TABLE . . . ALTER COLUMN statement to change the column constraint to NOT NULL. |
|