How to check data type in SQL?

Question

Can anyone tell me how to check data type in SQL?

Answer 1

You can use the following syntax to check the data type of a specific column in a table.

SELECT DATA_TYPE

FROM INFORMATION_SCHEMA.COLUMNS

WHERE

     TABLE_NAME = 'table_name' AND

     COLUMN_NAME = 'column_name' 

You can also use the describe statement to check the datatypes of all the columns of the table as follows: 

DESCRIBE table_name;

If you are interested in SQL, then check out this SQL Course by Intellipaat that offers instructor-led training, certification, and job assistance.