//nome, tipo e lunghezza delle colonne di una tabella
public void GetFieldsInfo(String _NomeTB)
{
String sQuery = @"SELECT
sys.COLUMNS.name,
sys.types.name,
sys.COLUMNS.max_length
FROM sys.COLUMNS JOIN sys.types
ON sys.COLUMNS.user_type_id = sys.types.user_type_id
WHERE object_id = (SELECT object_id FROM sys.objects WHERE name = ‘" + _NomeTB + "’)";
using (cmd1 = new SqlCommand(sQuery, connection))
myReader = cmd1.ExecuteReader();
}