Checking 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

0 vote336 views1 answer
Fetch second word from a string in ms sql
SQL
13 votes325 views2 answers
Oracle inner join
SQL
0 vote326 views1 answer
Select from another database
SQL
0 vote324 views3 answers
Above average salary in sql
SQL
1 vote417 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
7 votes319 views1 answer
Mysql unsafe update
SQL
0 vote344 views1 answer
Leftjoin in sql
SQL
0 vote345 views1 answer
Get create sql of hibernqte entity
SQL
25 votes360 views3 answers
How to use a database to see tables mysql
SQL
1 vote332 views1 answer
Mysql get latest duplicate rows
SQL