Thread: create a table with 3 column where sum of 2 column is 3rd column

create a table with 3 column where sum of 2 column is 3rd column

ex
col1 col2 col3
1 2 3
3 4 7
2 2 4

select col1,col2,col1+col2 from table

I need while creating the table, it have to effect the data base table

I think you can create a trigger on this table which will update the value of third column if there is any insert/update on that table.

That's the only way I think is to fulfill your requirement.


---V V---
Vikas Vaidya

now i got the answer


this is the answer


CREATE TABLE sample6
(
col1 int ,
col2 int,
col3 as(col1 + col2)
)