Alter table tablename ADD(columnname (data

I have one table and column is c1 pk, c2 not null,c3 not
null and 200 row in it and i add c4 column and value, how
can is possible

Question Posted / gayathri

Answer Posted / gayathri

Alter table tablename ADD(columnname (data_type) notnull)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of index in hive?

957

What is use of term?

1006

What is left join in postgresql?

992

What is materialized view. What are different methods of refresh?

1327

What is cursor status?

1135

What is a recursive stored procedure?

1093

what is not null constraint? : Sql dba

963

What is identity column in sql server?

985

Is hadoop a nosql?

946

What is the difference between truncate and drop statements?

1079

What is the example of procedure?

873

Is left join inner or outer by default?

972

what is a trigger in mysql? Define different types of trigger. : Sql dba

1007

What are pl sql data types?

949

What is difference between procedure and trigger?

914