microsoft / microsoft/DacFx

computed columns in external tables

Open
#431 0 comments 1 reaction 0 assignees View on GitHub
enhancement
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

Computed columns are supported on external tables in SQL, but are not supported on external tables in SQL projects.

https://developercommunity.visualstudio.com/t/Problem-with-adding-external-table-with-/10580514

https://learn.microsoft.com/en-us/answers/questions/1526682/how-to-add-external-table-with-computed-column-in

https://stackoverflow.com/questions/43365947/calculated-columns-in-sql-server-external-table

Computed columns seem to be supported on external tables across SQL Server, Azure SQL, and DW: https://learn.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql

Contributor guide

Open the contributing guide

Research direction

No source file, test, or entry point is named. Start by reproducing the external-table computed-column case in a SQL project and compare it with the supported SQL syntax described in the linked documentation. Done means SQL projects accept and preserve computed columns on external tables.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.