/SQL/How to check data type in sql server

How to check data type in sql server

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

Checking data type in sql server

SELECT COLUMN_NAME,
       DATA_TYPE,
       IS_NULLABLE,
       CHARACTER_MAXIMUM_LENGTH,
       NUMERIC_PRECISION,
       NUMERIC_SCALE
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='your_table_name';

Source: bigdata-etl.com

Similar codes

1 vote193 views4 answers
Sequelize migration default value
SQL
0 vote222 views1 answer
Mysql value ends with
SQL
1 vote194 views2 answers
Oracle difference between two dates in seconds
SQL
2 votes199 views1 answer
Sql ignore accents
SQL
0 vote227 views1 answer
Executescalar in sql server
SQL
2 votes206 views1 answer
Sqlite indexes
SQL
1 vote234 views1 answer
Postgresql blocked on mac
SQL
0 vote202 views1 answer
Drop a field in psql django
SQL
0 vote218 views1 answer
Mysql change timestamp on update
SQL
1 vote219 views1 answer
Liquibase alter column type / length
SQL