If table is empty (means no records are there) then we can add the constr

If we have n no of columns in a table, can we add new
column in that table with not null constraint?

Question Posted / chandan kumar

Answer Posted / chandan kumar

If table is empty (means no records are there) then we can
add the constraint.

alter table tablename add (col_name datatype not null)

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Is pl sql still used?

970

Can we insert delete data in view?

942

What do we need to check in database testing?

1012

Is id a reserved word in sql?

1139

Can we create index on primary key?

959

what is recursive stored procedure? : Sql dba

976

How to pronounce postgresql?

1049

What is the difference between microsoft access and sql?

1012

Explain raise_application_error.

1083

Is postgresql a nosql database?

1149

Which version of sql do I have?

1048

What is rtm stands for?

1091

explain primary keys and auto increment fields in mysql : sql dba

965

What has stored procedures in sql and how we can use it?

1067

What is package in pl sql?

1008