/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

6 votes304 views2 answers
Sql sequence
SQL
1 vote294 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote297 views1 answer
Mysql select random rows large table
SQL
4 votes286 views1 answer
Group by mysql and concatenate string
SQL
1 vote281 views4 answers
Sequelize migration default value
SQL
16 votes286 views3 answers
Jwt secret key generator laravel
SQL
0 vote278 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote309 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
6 votes330 views2 answers
How to get last element sql
SQL
0 vote271 views1 answer
Power query case when
SQL