When traversing a Dacpac
via C# code, I am able to figure out which columns are referenced in a computed column (GetReferenced(Microsoft.SqlServer.Dac.Model.Column.ExpressionDependencies)
), and what the expression for the column is (Microsoft.SqlServer.Dac.Model.Column.Expression
property). What I cannot find, is the datatype of the computed column.
Besides that, I also cannot find a way to retrieve the columns of a FileTable
table (although this is a static set of columns).
Search engines won't bring me far; there aren't that many resource to be found on this topic.