Skip to content

ErcanOPAK.com

  • ASP.Net WebForms
  • ASP.Net MVC
  • C#
  • SQL
  • MySQL
  • PHP
  • Devexpress
  • Reportviewer
  • About
SQL

How to Alter a Computed Column in SQL?

- 25.09.19 | 22.11.19 - ErcanOPAK

There is NO way to alter computed column. You have to drop and recreate it.

Let’s say you have a table with 3 column. And the 3rd one is the sum of the other two:

CREATE TABLE MyTable (Column1 int, Column2 int, Column3 AS Column1 + Column2);

If you want to change that computed column as multiply of the other two. Then:

-- First, You must Drop The Computed Column
ALTER TABLE MyTable
DROP COLUMN Column3;

-- And Then You can Create The New Computed Column
ALTER TABLE MyTable
ADD Column3 AS Column1 * Column2;

Related posts:

How to find records based on CAPITAL and small letters in SQL Query?
Get the User Name and Domain Name from an Email Address in SQL
Update Column with row_number() in SQL
List all Foreign Keys referencing a given table in SQL Server
How to return only the Date part from SQL Server DateTime datatype
Post Views: 89

Post navigation

How to solve “A cursor with the name already exists” problem?
How to Solve The ‘Object reference not set to an instance of an object’ error in Batch Edit mode for ASPxGridView

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

April 2021
M T W T F S S
 1234
567891011
12131415161718
19202122232425
2627282930  
« Jan    

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (243)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (194)
  • How to make some specific word(s) Bold or Underline in ReportViewer (187)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (183)
  • Confirm before process with ASPxButton in Devexpress (172)
  • ASPxGridView – Disable CheckBox based on condition in GridViewCommandColumn (170)
  • Find numbers with more than two decimal places in SQL (168)
  • Devexpress ASPxGridview Column Grouping in Code (164)
  • DATEADD Function in SQL (163)
  • Tense Changes When Using Reported Speech (160)

Recent Posts

  • How to check for ‘IS NOT NULL’ And ‘IS NOT EMPTY’ string in SQL
  • How to auto-scroll or manually to end of div when data is added
  • Filter Rows By Max Date in SQL
  • How to Validate a DateTime in C#?
  • Convert comma separated string into a List in C#
  • Converting a List to a comma separated string in C#
  • How to add placeholder to Multiple Selection DropDownList in Asp.Net MVC
  • How to use toFixed() for Float numbers in Javascript
  • Convert List to List in one line in C#
  • How to use column search in datatable when responsive is false

Recent Posts

  • How to check for ‘IS NOT NULL’ And ‘IS NOT EMPTY’ string in SQL
  • How to auto-scroll or manually to end of div when data is added
  • Filter Rows By Max Date in SQL
  • How to Validate a DateTime in C#?
  • Convert comma separated string into a List in C#

Most Viewed Posts

  • Get the First and Last Word from a String or Sentence in SQL (243)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (194)
  • How to make some specific word(s) Bold or Underline in ReportViewer (187)
  • How to solve “Response.Redirect cannot be called in a Page callback” for DevExpress Components (183)
  • Confirm before process with ASPxButton in Devexpress (172)

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter

powered by XBlog Plus WordPress Theme