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

1 vote97 views1 answer
Mysql check if string contains comma separated
SQL
0 vote117 views1 answer
Mysql extract day from date leading zero
SQL
3 votes56 views1 answer
How to get list of synonyms in oracle
SQL
4 votes113 views1 answer
Id increment ms sql server
SQL
0 vote112 views1 answer
Database schema for mcqs type exam in sql
SQL
1 vote90 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
16 votes127 views1 answer
Sql comment'
SQL
0 vote111 views2 answers
Close external port 3306 with iptables
SQL
0 vote99 views1 answer
How to see password mysql vestacp
SQL
1 vote144 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL