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

Explain correlated query work?

992

Which is faster union or join?

903

Does group by remove duplicates?

983

What is the purpose of normalization?

997

Does sql between include endpoints?

955

What is varchar data type in sql?

1016

What is a data manipulation language?

966

Define commit?

941

What is a delimiter in sas?

981

How to display the current date in sql?

1011

How do you optimize a stored procedure query?

939

Why is normalization important?

973

What are the usages of sql?

1014

how do you control the max size of a heap table? : Sql dba

924

What is sql and db2?

944