/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 vote464 views1 answer
Difference between where and having clause
SQL
0 vote391 views1 answer
Add week ending date sql server
SQL
15 votes353 views3 answers
Find duplicate keys in mysql
SQL
0 vote374 views1 answer
Full outer join in mariadb mysql
SQL
0 vote357 views1 answer
Create query in where clasue
SQL
1 vote365 views1 answer
Mysql view current queries
SQL
11 votes338 views2 answers
Sql rank
SQL
5 votes357 views2 answers
Add column postgres with default value
SQL
11 votes364 views1 answer
Oracle view ddl
SQL
0 vote356 views1 answer
Initcap in mysql
SQL