samehzagloul

I ran the query against AdventureWorks and the join to data type included column names as a type

Here is a sample of the output

TableNameColumnNameNameLength

AddressAddressIDint4

AddressAddressLine1nvarchar120

AddressAddressLine1AccountNumber120

AddressAddressLine1Name120

AddressAddressLine1OrderNumber120

AddressAddressLine1Phone120

AddressAddressLine2nvarchar120

AddressAddressLine2AccountNumber120

AddressAddressLine2Name120

AddressAddressLine2OrderNumber120

AddressAddressLine2Phone120