/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

14 votes201 views2 answers
How to auto increment in sql
SQL
5 votes197 views1 answer
Oracle ora-00054 causes
SQL
1 vote161 views1 answer
Oracle boolean to varchar
SQL
1 vote205 views1 answer
Sql Split string function
SQL
0 vote215 views1 answer
Postgresql linux password
SQL
7 votes193 views1 answer
Safe mode mysql
SQL
0 vote204 views1 answer
Mysql root localhost run
SQL
0 vote204 views2 answers
Sqlite unix timestamp
SQL
7 votes206 views1 answer
Mysql iif
SQL
6 votes206 views5 answers
Mysql get last insert id
SQL