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

5 votes211 views2 answers
Mysql create database charset utf8mb4
SQL
1 vote191 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote186 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
8 votes162 views1 answer
Similarities between ddl and dml
SQL
1 vote187 views1 answer
Database Queries
SQL
0 vote395 views1 answer
Why do we need data structure in sql
SQL
2 votes209 views3 answers
Mysql list tables by size
SQL
0 vote269 views1 answer
Sql delete caracter list
SQL
1 vote332 views1 answer
Postgres set column based on another column
SQL
0 vote224 views1 answer
How to get parent and child record in single query using sql
SQL