information_schema.geometry_columns.geometry_type

Note:

Integer reflecting the type of geometry stored in this column (see table below).