Menu
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.
331
Go to your database, right click on tables, select “New Table” option. Create all columns that you require and to mark any column as computed, select that column and go to column Properties window and write your formula for computed column.
A computed column in SQL Server is a virtual column that computes its values from an expression. We can use a constant value, function, value derived from other columns, non-computed column name, or their combinations. SQL Server does not store these virtual columns physically, so it does not require any storage.
Create a new diagram, add your table, and choose to show the formula column in the diagram's table view. Change the columns formula to an empty string ('') or something equally innocuous (probably such that you don't change the column's datatype). Save the diagram (which should save the table). Alter your function.
Add a column to the left or right Under Table Tools, on the Layout tab, do one of the following: To add a column to the left of the cell, click Insert Left in the Rows and Columns group. To add a column to the right of the cell, click Insert Right in the Rows and Columns group.
The syntax I was looking for is:
alter table TABLE_NAME add [column_name] as (**COLUMN-SQL**) If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With