Toad World® Forums

calculated column in the diagram

When adding calculated columns in the query diagram, there is a required entry to “attach to table”, I do not wish to add any tables to the database. is there way to use the diagram and add a calculated column ?

The calculated column is not really added to the database. The query builder needs to treat it as a column and to do this it needs to be part of a table. This is strictly for the Query Builder.