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

What is data abstraction in sql?

1066

What does pragma mean?

1131

Is sql database free?

1025

What is over () in sql?

1013

Why are aggregate functions called so?

1012

What is sap sql?

1030

How do I run a pl sql program?

1191

How can the performance of a trigger be improved?

1088

Determine if oracle date is on a weekend?

1089

Why do we need view in sql?

1039

What are database links used for?

1095

Why is the cursor important?

1079

What is sql deadlock?

1216

Is it possible to pass parameters to triggers?

1160

how to create a test table in your mysql server? : Sql dba

1056