SQL statement to get column type

Question

1 Answer

0 votes

1 answer

asked Feb 12, 2021 in SQL by RohitSingh (2.6k points)

0 votes

1 answer

asked Dec 20, 2020 in SQL by Appu (6.1k points)

0 votes

1 answer

asked Jul 22, 2019 in SQL by Tech4ever (20.3k points)

0 votes

1 answer

asked Jul 30, 2019 in Salesforce by Kartik12234 (11.9k points)

0 votes

1 answer

asked May 5, 2020 in SQL by Sudhir_1997 (55.6k points)

Soni Kumari · Answer 1 · 2019-07-06T11:41:20+0000

For SQL Server, try using this code:

SELECT DATA_TYPE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'yourTableName' AND
COLUMN_NAME = 'yourColumnName'