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 vote142 views1 answer
Not equal to blank in mysql
SQL
9 votes147 views3 answers
Find all tables with column name
SQL
0 vote144 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
1 vote1.8K views1 answer
Dropping a constraint in ms sql
SQL
8 votes148 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
4 votes138 views1 answer
Oracle select first 10 rows
SQL
2 votes145 views2 answers
Laravel query builder toSql
SQL
0 vote155 views1 answer
Postgresql inline table
SQL
0 vote134 views1 answer
Mysql undo delete
SQL
0 vote147 views1 answer
Sql list dates between two dates
SQL