Expanding wildcard for @table variables not displaying computed columns

ggeier

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.

Tianjiao_Li

Thanks for reporting this issue! It's logged as SP-7431 in our internal bug tracking system now. Please keep an eye on the release note!

DBAJohnny

I am having this exact issue in SQL Prompt version 10.1.5.14730.