/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

0 vote539 views1 answer
Sql change a colum to unique
SQL
6 votes410 views4 answers
Mysql group by month
SQL
4 votes333 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
7 votes358 views2 answers
What is sql clause
SQL
0 vote447 views1 answer
Create view in sql server that contain multiple select statements
SQL
2 votes375 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote414 views1 answer
Alternative for LIMIT sql
SQL
1 vote382 views1 answer
Key validation sql
SQL
0 vote391 views1 answer
Sql values that contains certain multiple ids
SQL
17 votes382 views4 answers
Show tables sql server
SQL