how do you add a computed column to a table

Question

How can I add a computed column to a table that already exists?

Answer 1

This can be easily achieved by using Alter keyword,

Let’s have look:

For example, we want to add GDP to the Table name as Nation:

alter table Nation

add [GDP] as (**COLUMN-SQL**)

To Explore More About this, Checkout SQL certification by Intellipaat.