How do you add a computed column to a Table?

tsql ddl
Chris Pfohl picture Chris Pfohl · Jun 15, 2012 · Viewed 70k times · Source

How can I add a computed column to a table that already exists? S.O. has Computed Column Help - TSQL but no information about adding them.

Answer

Chris Pfohl picture Chris Pfohl · Jun 15, 2012

The syntax I was looking for is:

alter table TABLE_NAME
add [column_name] as (**COLUMN-SQL**)

Related questions

Alter Table Add Column Syntax

I'm trying to programmatically add an identity column to a table Employees. Not sure what I'm doing wrong with my syntax. ALTER TABLE Employees ADD COLUMN EmployeeID int NOT NULL IDENTITY (1, 1) ALTER TABLE Employees ADD CONSTRAINT PK_Employees PRIMARY KEY …

Read More
Test Column exists, Add Column, and Update Column

I'm trying to write a SQL Server database update script. I want to test for the existence of a column in a table, then if it doesn't exist add the column with a default value, and finally update that column …

Read More
How do I conditionally create a table in Sybase (TSQL)?

OK, so Sybase (12.5.4) will let me do the following to DROP a table if it already exists: IF EXISTS ( SELECT 1 FROM sysobjects WHERE name = 'a_table' AND type = 'U' ) DROP TABLE a_table GO But if I try to do …

Read More