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

How do I make sql search faster?

1003

How to add new employee details in an employee_details table with the following details

1091

How is sql used in oracle?

1013

Can we rollback after truncate?

1035

Explain aggregate functions are available there in sql?

1012

Whis is not false in primary key?

1462

What is a natural join sql?

992

What is crud stand for?

1004

Mention what plvcmt and plvrb does in pl/sql?

1144

What is dense_rank?

938

How many indexes can be created on a table in sql?

1059

Is a secondary key the same as a foreign key?

1041

What are different types of sql commands?

1123

Why do we need a foreign key?

1104

Which are the different types of indexes in sql?

1064