Expanding wildcard for @table variables not displaying computed columns

ggeierggeier Posts: 30 Bronze 2
The expand wildcard feature is not working for @table variables. If I declare a @table with computed columns, then expand the wildcard, only the non-computed columns will be shown. For example:

declare @t table ( C1 varchar(9) ,C2 as ('a' + C1) ,C3 as ('z') ) select * from @t

If I expand the asterisk, it'll show:
select C1 from @t<br>
All other tables don't have this issue. I am using version: 9.4.8.7733.
Tagged:

Best Answer

Answers

Sign In or Register to comment.