In SQL Server, we would like to see both the name and type of each column so we can exclude columns based on their type.

In our use-case, we sync end user data via Fivetran and don't always know the columns to include. Instead we have a black list of columns to exclude by name. This part works fine.

But sometimes large character / binary blobs are stored in source databases (eg. base64 images) which are of no use and would just increase source, destination and network load to include.