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

How do I count records in sql?

1047

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

2139

What is not equal in sql?

1188

What is sql prepared statement?

1030

Which one is faster ienumerable or iqueryable?

984

What are expressions?

1059

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1037

What are the different types of constraints?

1273

What are stored procedures used for?

1047

What is primary key and foreign key?

1009

What is the difference between sql and t sql?

1101

What is synonyms?

1115

What mean sql?

1050

Can a table contain multiple primary key’s?

1153

What is the difference between sql and isql*plus?

1157