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.



Discussion

No Comment Found

Related InterviewSolutions