1. Vertabelo
  2. Ideas
0
Completed

Define a computed column

Kindler Chase 10 years ago • updated by anonymous 10 years ago • 1
Is there a way to create a computed column, specifically for SQL Server? ex:

create table Entries
(
    Id int identity (1,1) not null,
    Process varchar(50) not null,
    ProcessDate datetime not null,
    Date as convert(date, ProcessDate),
    Time as convert(time, ProcessDate)
)

The last 2 columns are computed and I'd like to be able to define them with Vertabelo. Is that possible? If not, I'd like to suggest it as a feature.

Answer

Answer
Completed
anonymous 10 years ago
Well, you can define do this, but not straight. In "Table properties" you have a section called "Additional SQL scripts." You can add "After create table" statement like this:
ALTER TABLE Entries 
DROP COLUMN Date;

ALTER TABLE Entries
ADD Date AS convert(date, ProcessDate);

This way you'll have both visual representation on the diagram and the proper behavior (a computed column).
I know it's a kind of workaround but adding tons of options like this to our UI would make Vertabelo unusable.
GOOD, I'M SATISFIED
Satisfaction mark
Satisfaction mark by Kindler Chase 10 years ago
Answer
Completed
anonymous 10 years ago
Well, you can define do this, but not straight. In "Table properties" you have a section called "Additional SQL scripts." You can add "After create table" statement like this:
ALTER TABLE Entries 
DROP COLUMN Date;

ALTER TABLE Entries
ADD Date AS convert(date, ProcessDate);

This way you'll have both visual representation on the diagram and the proper behavior (a computed column).
I know it's a kind of workaround but adding tons of options like this to our UI would make Vertabelo unusable.

Customer support service by UserEcho