hi Alter Table <Table Name> ADD( <Column name> <data ty

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 / ramprasad.s

9 Answers
11993 Views
I also Faced
E-Mail Answers

Answer Posted / ramprasad.s

hi

Alter Table <Table Name> ADD( <Column name> <data type>)

you can insert values by using <update> with reference

to the existing values of the other columns.
bye

sun_ramprasad@yahoo.com

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of function in sql?

1094

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1001

What are operators available in sql?

1046

What does sql stand for?

994

Is pl sql a scripting language?

1031

Can we enter data in a table in design view?

969

Why stored procedures are faster than query?

1026

How do you optimize a stored procedure in sql?

957

Can we delete column in sql?

1099

What do you understand by exception handling in pl/sql?

1035

What is %s in sql?

1016

What is the purpose of my sql?

950

How many postgresql users are there, worldwide?

1061

What is the difference between sql and mysql?

1117

what is user defined functions? : Sql dba

1031