SQL Server all fields

sql_server_all_fields.sql

SELECT SchemaName = c.table_schema,
         TableName = c.table_name,
         ColumnName = c.column_name,
         DataType = data_type,
		 Validate = 'SELECT TOP 1 ' + c.column_name + ' FROM ' + c.table_name
FROM information_schema.columns c
INNER JOIN information_schema.tables t
    ON c.table_name = t.table_name
        AND c.table_schema = t.table_schema
        AND t.table_type = 'BASE TABLE'
where c.column_name like '%tel%'
ORDER BY  SchemaName, TableName, ordinal_position