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
Post a Comment