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.