/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 vote340 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote282 views1 answer
Select * where id = 1,2,3
SQL
11 votes269 views2 answers
Having in sql
SQL
0 vote280 views1 answer
How to select a row in sql
SQL
0 vote312 views1 answer
Get last inserted primary key
SQL
4 votes309 views1 answer
How to drop a database in sql server when it is in use
SQL
5 votes273 views1 answer
Oracle create table comment
SQL
1 vote258 views1 answer
Select statement to print longest name
SQL
2 votes264 views1 answer
Apex date today add days
SQL
0 vote279 views1 answer
Sql select duplicates based on two columns
SQL