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 vote262 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote261 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
3 votes259 views2 answers
Wp do sql query from function
SQL
11 votes255 views6 answers
Distinct sql
SQL
0 vote214 views2 answers
Avg() sql
SQL
11 votes231 views4 answers
Query DISTINCT
SQL
1 vote237 views1 answer
DATE_SUB postgres
SQL
1 vote222 views1 answer
Import database from a file using mysql commandline
SQL
24 votes265 views4 answers
Postgres delete database
SQL
0 vote219 views1 answer
What is the essence of SQL?
SQL