alter table <table-name> add(<column-name> datatype [constrain

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 / srinivas

Answer Posted / srinivas

alter table <table-name> add(<column-name> datatype
[constrains]);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1074

How do you remove duplicates without using distinct in sql?

976

what are the different functions in sorting an array? : Sql dba

1016

How does left join work in sql?

1001

What is the least restrictive isolation level? : Transact sql

1063

What is lookup table in sql?

1045

What is dbo in sql?

962

How do you concatenate in sql?

1027

What is a rank in sql?

963

How do I access sql anywhere database?

969

What are different types of queries in sql?

1121

what is primary key? : Sql dba

1028

How can you know that statistics should be updated?

1079

what is a control file ? : Sql dba

1036

What is the difference between microsoft sql and mysql?

960