microsoft / DacFx

SQL Server database schema validation, deployment, and upgrade runtime. Enables declarative database development and database portability across SQL Server versions and environments.
https://aka.ms/sqlpackage-ref
MIT License
292 stars 15 forks source link

computed columns in external tables #431

Open dzsquared opened 3 months ago

dzsquared commented 3 months ago

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