Answers for "how to get column data type from table in sql"

how to check data type in sql server

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

Posted by: Guest on August-21-2020

Code answers related to "how to get column data type from table in sql"