How we can add a NOT NULL column to a table

Describe how we can add a NOT NULL column to a table?

E

Expert

Verified

First of all, add the column as NULL. Then employ UPDATE to add data to each and every row. Finally employ an ALTER TABLE . . . ALTER COLUMN statement to modify the column constraint to NOT NULL.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.