Which Of The Following Statement Can Be Used To Remove The Not #357
Which of the following statement can be used to remove the NOT NULL constraint from an existing column?
This multiple choice question (MCQ) is related to the book/course gs gs115 Structured Query Language. It can also be found in gs gs115 SQL Constraints - SQL Not Null - Quiz No.1.
Which of the following statement can be used to remove the NOT NULL constraint from an existing column?
ALTER TABLE table_name ALTER COLUMN column_name data_type IS NULL;
ALTER TABLE table_name ALTER COLUMN column_name data_type NOT NULL;
ALTER TABLE table_name ALTER COLUMN column_name data_type;
ALTER TABLE table_name ALTER COLUMN column_name data_type NULL;