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

Why do we use subquery?

1002

How do you identify a primary key?

1057

What is query optimization in sql?

973

Is sql better than access?

1006

What port does sql server use?

1050

What is a delimiter in sas?

1043

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3563

What are the advantages of indexing?

977

Why stored procedure is faster than query?

1044

What is relationship? How many types of relationship are there?

1163

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

996

what is a materialized view? : Sql dba

1055

Can you skip header records while loading? : aql loader

1037

how to write date and time literals? : Sql dba

953

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1102