How to find and find a table column in a database


In which tables is a column, what is the type and size of this column, how do we find it? Thank you.