Funzione per trovare tutti i capi di tutte le tabelle su tutto il db.

FindTypeFieldFromAllDb.sql

#Databse: Microsoft SQL Server.

USE <database_name>
GO
SELECT table_name 'table_name',
column_name 'Column Name',
data_type 'Data Type',
CHARacter_maximum_length 'Maximum Length'
FROM information_schema.columns
WHERE data_type = <Type to field>
GO 

#Example

USE wingpfull
GO
SELECT table_name 'table_name',
column_name 'Column Name',
data_type 'Data Type',
CHARacter_maximum_length 'Maximum Length'
FROM information_schema.columns
WHERE data_type = 'image'
GO