How to get COLUMN TYPE in SQL

Published: 05 March 2022
on channel: Learn SQL

5,841

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

Watch video How to get COLUMN TYPE in SQL online without registration, duration hours minute second in high quality. This video was added by user Learn SQL 05 March 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,841 once and liked it 36 people.

7,349

184