Extract the Database type from the Table column
I am generating SQL from BIML to create a table but cant work out how to get the column database datatype.
I have imported a table into a BIML table object and tagged certain columns i want to filter out.
I am using a lambda expressions to iterate through the columns to generate the SQL but i am unable to retrieve the database type of the columns from the column object.
is there a way to get the database type of the column? or should i be looking at this from another perspective?