Is it possible to create a computed column in a Visual Studio database project? -


Is it possible to create a computed column in the Visual Studio 2012 database project? 'Compute column specification -> formula' is a property, but it has gone deeper and it is not possible to enter the value in it.

Edit Computing column is also VS Depth in 2013

The only way to add a calculated column is to add it to t -SQL pane for example:

  Make Table [DBO]. [Person] ([first name] is not VARCHAR (50), [last name] is VARCHAR (50), [full name] AS ([FirstName] + '' + [last name]);  

After defining the column in T-SQL, the "Formula" option in properties will be editable. An option for "Ins Persist" will also be visible.


Comments

Popular posts from this blog

winforms - C# Form - Property Change -

javascript - amcharts makechart not working -

java - Algorithm negotiation fail SSH in Jenkins -