How to get COLUMN TYPE in SQL

This video is about how to get COLUMN TYPE in SQL.

Script:
SELECT COLUMN_NAME, DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'persons'

Keywords:
how to get COLUMN type in SQL,column type sql,column type in sql,sql column type,type of columns in sql,get column type sql,get column type in sql,get sql column type,type of columns in table sql,sql type of column table,type of column in table,sql type of column in table, sql column types, sql column types query, sql column type, sql column type query, column type sql, column types sql, column type in sql, column type sql query, columns type sql, column types sql query, field type sql, sql server, learn sql, sql