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 difference between delete and truncate statement in sql?

1076

what is the functionality of the function htmlentities? : Sql dba

970

What are the qualities of 2nf?

1040

What is dynamic sql in pl sql?

1040

what is self-join? : Sql dba

1170

What is the difference between truncate and drop statements?

1195

Name the operator which is used in the query for pattern matching?

960

List the various privileges that a user can grant to another user?

1047

Can a table have no primary key?

1068

What is a sql statement?

972

In what condition is it good to disable a trigger?

1015

What is sql procedures and functions?

1012

what is the command line end user interface - mysql? : Sql dba

984

What is right join in sql?

1097

what is data manipulation language? : Sql dba

1022