How to know the type of a table in SQL

Answer 1

if you refer to the type of data in a column of an specific table:
use

describe nameoftable;

this shows the types of all the columns in that table

Answer 2

desc TABLE_NAME