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 vote333 views1 answer
Apex ORA-20999
SQL
-1 vote330 views1 answer
Mysql case when multiple conditions
SQL
0 vote303 views1 answer
What are the aggregate function in sql
SQL
5 votes354 views4 answers
Traduction
SQL
0 vote267 views1 answer
Microsoft sql server management studio clear cache
SQL
1 vote306 views2 answers
T-sql random number for each row
SQL
0 vote353 views1 answer
How to make sure two tables have same exact data in sql
SQL
0 vote316 views1 answer
Use where instead of join
SQL
0 vote306 views1 answer
Myswql show full processlist
SQL
0 vote334 views1 answer
Error Code: 1140. In aggregated query without GROUP BY, expression #3 of SELECT list contains nonaggregated column 'grepper_history.search_history.term'; this is incompatible with sql_mode=only_full_group_by
SQL